DATA PREPARATION

How to make a chart from Excel

Arrange a clean rectangular worksheet, choose the relevant sheet and map only the columns required by the destination chart.

Prepare the worksheet

Place field names in one header row and keep one observation or category per row. Avoid merged headings, decorative blank rows and mixed units in one numeric column.

For several series, use one category column followed by consistently named numeric columns.

Open or paste the data

The Excel workflow reads local XLSX files up to 5 MB, exposes supported worksheets and lets you confirm whether the first row contains headings. You can instead paste a rectangular range copied from Excel.

Stored cell values are read; formulas and macros are not executed, and workbook formatting or pivot charts are not reproduced.

Map, validate and export

Choose a compatible chart and map each semantic role to a different source column. The validated Project v2 handoff opens the full editor without placing cells in the URL.

Correct the chart, label units, then export SVG, PNG, JPEG, raster-backed PDF, source CSV or editable project JSON.

WORKED EXAMPLE

Example data

Demonstration values only-replace them with your own source data.

MonthRevenueOrders
January12084
February14591
March13888

Try the working tools

Bar Graph MakerLine Graph MakerScatter Plot MakerGrouped Bar Chart Maker

Related workflows and guides

Convert Excel data to a chart
GUIDE FAQ

Questions about this task

Supported sheets appear in the worksheet selector.