Chart Maker from Pasted Data
Put the labels in the first column and the numbers in the columns after it. Pick a chart type, add titles and download a picture, or an SVG that stays sharp at any size.
Drag a file here or choose one
Worked examples
Two series
Month,Tea,Coffee Jan,120,80 Feb,110,95
A grouped bar chart with two bars for each month
The axis runs from 0 to 150 in steps of 50.
A pie chart
Region,Sales North,50 South,25 West,25
Slices of 50%, 25% and 25%
Shares are worked out from the total of 100.
About Chart Maker from Pasted Data
Paste a table and get a chart. The first column supplies the labels and every other column that holds mostly numbers becomes a set of bars or a line, so several columns give grouped bars, lines side by side or a stacked chart. Amounts with currency signs and thousands commas are understood, and the axis uses round numbers so the gridlines are easy to read.
A pie or donut chart shows one set of numbers as shares of a whole, so it uses the first column of numbers and leaves out zero and negative values. Add a title and labels for the axes, choose colours that are easy to tell apart for people who are colour blind, and decide whether to print the values on the chart. Download a PNG, saved at double size so it stays crisp in a report or presentation, or an SVG that can be resized without losing quality.
How to use Chart Maker from Pasted Data
- Paste your table, with labels in the first column and numbers in the columns after it, or open a file.
- Choose the chart type, colours and size.
- Add a title and axis labels, and choose whether to show values and the key.
- Download the PNG or the SVG.
Common uses
- Putting monthly figures into a report or slide
- Showing how parts add up to a total with a stacked chart
- Making a quick pie chart of shares
- Producing a picture to paste into an email or document
Frequently asked questions
How should I lay out the table?
Labels in the first column, such as months, and one column of numbers for each series, such as Tea and Coffee. The first row holds the names of the series.
Which chart suits which data?
Bars compare amounts between categories, lines show change over time, stacked bars show how parts make up a total, and a pie or donut shows shares of one total with a handful of slices.
What is the difference between PNG and SVG?
A PNG is a fixed size picture that works everywhere. An SVG is a drawing that stays sharp at any size and can be edited in a drawing program.
Why are some of my columns missing from the chart?
Only columns where at least half the cells are numbers are charted. A column of notes is left out.
Is there a limit on the number of rows?
The first 200 rows are charted. A chart with more bars than that is too crowded to read.