Your data is in a spreadsheet. Here's how to turn it into a figure a journal will accept — without it looking like a default Excel chart.

Excel is where most experimental data lives, but Excel's default charts rarely meet publication standards: the styling looks generic, the resolution is too low, and the statistics aren't built in. Here's how to go from a spreadsheet to a journal-ready figure.

Why Excel charts fall short for papers

Low resolution — Excel exports are often below the 300 DPI journals require.
Generic styling — default colors, gridlines, and fonts that scream "spreadsheet."
No built-in statistics — no significance testing, error bars, or post-hoc comparisons without manual work.
Limited chart types — no easy box plots, violin plots, volcano plots, or survival curves.

Step 1 — Structure your data correctly

How you arrange your spreadsheet determines how easily any tool can chart it. Two common, valid layouts:

Long format: one column for the group/condition, one for the value, one row per measurement.
Wide format: each group is its own column, with replicate values down the rows.

Both are fine — what matters is consistency: keep your group labels in one place and your numeric values clearly separated. Avoid merged cells, stray text in numeric columns, and notes mixed into the data.

Step 2 — Choose the right chart for your data

Comparing group means → bar chart with error bars (and individual data points overlaid — increasingly expected).
Showing distributions → box plot or violin plot.
Relationship between two variables → scatter plot (with regression if appropriate).
Change over time → line chart.
Differential expression → volcano plot.
Survival / time-to-event → Kaplan-Meier curve.

Step 3 — Add the right statistics

If you're comparing groups, your figure usually needs a statistical test and significance indicators. Choose the test based on your groups and data distribution and show error bars (SEM or SD — state which).

Step 4 — Style to publication standard

Limited, purposeful color palette (ideally colorblind-safe).
Clean axes, legible fonts, no unnecessary gridlines.
Consistent styling if the chart will join a multi-panel figure.

Step 5 — Export at journal resolution

Export at 300 DPI minimum (some journals want 600+), in the required format (TIFF, PDF/EPS, or high-res PNG), sized to the journal's column width.

The fast path

Instead of fighting Excel's chart engine and then re-styling in Illustrator, you can paste your Excel data directly into FigureGuild — it reads common spreadsheet layouts (long and wide), builds a publication-styled chart, computes the appropriate statistics locally, and exports at journal resolution.

Copy your data from Excel.
Paste it into FigureGuild's Graph Builder.
Pick the chart type; statistics and error bars are computed automatically.
Export to PNG, PDF, SVG, or TIFF at 300–1200 DPI.

Try it free at figureguild.com.

Common mistakes

Exporting below 300 DPI.
Leaving Excel's default styling (gridlines, generic colors).
Forgetting error bars or not stating SEM vs SD.
Messy data layout (merged cells, text in numeric columns).

Final thought

Going from spreadsheet to publication figure is mostly about three things: clean data structure, the right chart and statistics, and export at journal resolution. Do those, and your figure will pass review — whether you build it in Excel + a vector editor or in a tool built for the job.

FigureGuild turns Excel data into publication-grade figures — paste your data, get a chart with the stats done right. Free to try.