How to make a chart from Excel or Google Sheets

You have a table in Excel or Google Sheets. You need a chart for a report, a slide, or a quick answer. There are three sensible routes, and they are good at different things:

• Excel’s built-in chart — best when the chart stays inside the spreadsheet and the data changes often.
• An online paste-and-download tool — best when you need a clean image quickly, without rebuilding the sheet.
• An editable .xlsx export — best when someone else needs to keep changing the numbers or the chart later.

Step 1: Prepare the range

The layout of the range determines whether the chart is right before you even pick a type. Most tools — including ChartPaste — expect this shape:

The first row is headers — each header becomes a series name. The first column contains the labels on the axis. Everything else is numbers. A chart made from this range will have two series and three categories.

The rules that matter

• One number per cell. Do not put “$1,200” or “12 kg” into a numeric cell. Put the unit in the header — “Revenue (USD)” — and keep the cell a plain number.
• No merged cells inside the range. Merged cells look tidy in the sheet and break the table when copied.
• No blank rows or columns. A blank column is often read as the end of the table, so the data after it disappears.
• Watch the total column. A “Total” column is fine for a line or bar chart of totals, but it must be removed before a stacked chart — otherwise the total is stacked on top of its own parts and the bar is doubled.
• Keep dates consistent. Choose one format and use it for every row. Mixed formats are read as text, and text does not sort like dates.
• Same unit per column. Do not mix dollars and percentages in one series. If you need both, use a combo chart with two labelled axes.

Step 2: Copy the range

Select the cells — including the header row and the label column — and copy. You can copy either:

• a range in Excel or Google Sheets (tab-separated text is produced automatically), or
• plain CSV text from any other program.

Do not copy the formula bar or a single cell at a time; copy the whole rectangle. That is what preserves the table structure.

Step 3: Paste and pick the chart

Paste into the data box on ChartPaste. The table appears as an editable grid, and the tool suggests a chart based on the shape of the data. You can accept the suggestion or pick any of the 20 chart types yourself — the suggestion is a default, not a restriction.

If you are not sure which type fits the question, read how to choose a chart type first. A chart chosen for the question is worth more than a chart chosen for its colours.

Step 4: Fix anything that came through wrong

Because the grid is editable, a mistake in the source does not mean starting over. Click a cell and correct it. The three most common problems and their fixes:

Step 5: Export in the right format

PNG is the right choice when the chart is going into a slide, a document, a website or a social post. Standard resolution is fine on screen; the 2× option keeps text and lines crisp when the image is printed or shown on a high-density display.

An editable .xlsx file is the right choice when the chart is part of a report that someone else will maintain. The exported file contains both the data and a native Excel chart — not a picture of a chart — so the chart can be resized, restyled, and updated when the numbers change. A PNG cannot do that.

If a chart type cannot be exported to .xlsx, the tool says so next to the download button instead of silently giving you a file that does not work.

What happens to your data

Parsing, chart drawing and file generation all happen in your browser. The pasted table is not uploaded to a server, is not stored on a disk, and is gone when you close the tab. That matters more than it sounds: most of the time, the reason people avoid online chart tools is not the tool — it is the data.

A short checklist

• Headers in the first row, labels in the first column.
• Plain numbers in cells; units in the headers.
• No merged cells, blank rows, or hidden columns in the range.
• Total column removed before stacking.
• One unit per series; two units means a combo chart with two axes.
• PNG for sharing, .xlsx for editing later.