How to use
- Paste CSV (a table copied from Excel works too) or drop a
.csv,.tsvor.xlsxfile. The first row is read as the header. Sample data is preloaded. - Choose the chart type, the X axis column and one or more Y value columns. If the same X value appears several times, combine the rows with grouping (sum, average or count).
- Optionally change sorting, top N, titles, legend position, color palette, number format and data labels.
- Take it with Save PNG (1×, 2× or 3×, white or transparent background) or Copy image. The values behind the picture are available as Chart data CSV.
Choosing a chart type
| You want to show | Good chart | Notes |
|---|---|---|
| Sizes of items compared | Bar (vertical or horizontal) | Horizontal bars read better when item names are long |
| How parts add up to a total | Bar (stacked) | Series are stacked so you see both the total and the make-up |
| A trend over time | Line, Area | With only a few points, straight lines are more honest than curves |
| Share of a whole | Pie, Doughnut | Best with 5–6 items or fewer; otherwise use top N plus Other |
| Relationship or spread of two numbers | Scatter | X and Y must both be numbers (or dates) |
| Two measures with different units | Combo (bar + line) | The first Y column is bars, the rest are lines. “Secondary axis” puts the lines on the right-hand scale |
Grouping and top N
Rows with the same X value are combined into one item and calculated per Y column. Non-numeric values (n/a, blank cells) are left out of sum, average and count alike. For example, seven rows Apple 100, Pear 40, Apple 60, Orange 30, Grape 20, Pear 10, Orange n/a give:
| Item | Sum | Average | Count |
|---|---|---|---|
| Apple | 160 | 80 | 2 |
| Pear | 50 | 25 | 2 |
| Orange | 30 | 30 | 1 |
| Grape | 20 | 20 | 1 |
Keeping the top 2 leaves Apple 160, Pear 50 and Other 50 (Orange plus Grape). Top N picks by the largest totals and the result follows that order. Note that with average or count grouping, “Other” is simply the sum of the remaining values. “No grouping” draws one point per row. With more than 500 items only the first 500 are drawn.
Color palettes and accessibility
There are six palettes. Colorblind-safe (Okabe-Ito) is a widely used set designed so series stay distinguishable with red-green color vision deficiency. Do not rely on color alone: use the legend, data labels and the data table under the chart. That table is a real <table> with the same values that screen readers can read. On screen, text and grid colors follow the site’s light or dark mode; the saved PNG is always drawn in light colors so it fits a white document.
Why there is no SVG export
The charts are drawn by chart.js, which renders to a canvas and cannot produce vector output. We chose not to add another library just for SVG, so the export format is PNG (up to 3×). For print, save at 3×.
Good to know
- A pie chart draws only the first Y column, and negative values are drawn as 0 because they cannot be shown as slices.
- The
%number format only adds the sign (12.5 → 12.5%); it does not compute percentages. - Dates such as
2024-01-02and2024.1.2are recognized, and a scatter chart with dates on X labels its ticks as dates. - For Excel files you can pick the sheet. Formula cells are read as their calculated values.
Related tools: Excel & CSV Workbench, Column Statistics, Percentage Calculator, JSON to CSV Converter
Your data and files are processed only in this browser and are never sent to a server.