This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Tutorial: Stop writing ggplot2 code. Make publication figures directly in Excel

Figra is a free Excel add-in that brings ggplot2 figures directly into Excel, no R installation, no coding required. You can install it directly from your Excel add-in tab.

How it works

background via WebAssembly (webR).

Chart types

Histogram, box plot, violin plot, dot plot, bar chart, grouped variants, line plots, dose-response (IC50 / 4PL), clonogenic survival (LQ model), scatter plot enter image description here

Built-in statistical analysis

  • Auto-selects the appropriate test (Shapiro-Wilk, Levene's test or F-test, t-test / Wilcoxon / ANOVA / Kruskal-Wallis)
  • Post-hoc tests: Tukey, Dunnett, Bonferroni, Holm, Dunn
  • Significance displayed as stars, letters, or exact p-values
  • Exports statistical results directly to Excel cells

    ## Reproducibility: Load from Figure All data and settings are embedded invisibly in the exported PNG. Select the PNG in Excel and click "Load from Figure" to fully restore your data, settings, and chart type then ready to edit or reproduce at any time.

    ## Other features

  • Export at 300+ DPI (publication-ready)
  • Educational R code export. See the ggplot2 code behind your figure
  • Free to use

    ## Link https://h20gg702.github.io/figra-pages/ Microsoft AppSource: https://appsource.microsoft.com

ggplot excel statistic visualization r

Should post this to wetlab-orientated communities. There people might benefit from it. Here, I would assume everyone can use R/Python plotting libraries. Also, Excel does not scale with OMICS-scale data, so usecases in bioinformatics are limited.

Hi Atpoint, Yeah, that’s exactly the user I have in mind. I agree with you. For OMICS-scale analysis, I also use R/Python myself; Excel is not suitable. I’m in a lab that does both wet and dry work. Honestly, writing R code every time just to make a simple figure for wet experiments can be a bit tedious, and since the data is already in Excel, I wanted a way to visualize it directly from there. Thanks for the feedback.

Do you happen to know any good wetlab-orientated communities where this kind of tool might be useful?

0 answers

No answers yet.

Log in to answer this question.