Guides · Charts and diagramsChart guide

How to make a chart from your data with AI

An AI chart is only as good as the numbers and the question you give it. Paste clean data, say what the chart should show, choose the shape that answers that question, and check every value in the result.

Capabilities reviewed 2026-09-26

Method

Step by step

  1. Start from the question, not the chart

    Write one sentence about what the reader should learn: which region grew fastest, how spend split across teams, whether latency crossed the target. The question decides the chart type and what to emphasize.

  2. Paste the data as text

    Copy the cells from your spreadsheet and paste them into the prompt; they arrive as tab-separated rows, which work well. Vizify accepts image, audio, and video uploads only, so CSV, XLSX, and PDF files cannot be attached.

  3. Label units, periods, and sources

    State what each number measures and in what unit (USD thousands, percent, milliseconds), the period it covers, and where it came from if the chart needs a source line. Mixed units in one series are the fastest way to a misleading chart.

  4. Choose the chart shape

    Bars compare categories, lines show change over time, a pie or donut shows parts of one whole, a scatter shows the relationship between two measures, and a waterfall shows how a total was built up. If you are unsure, name the question and ask Vizify to recommend a shape.

  5. Say what to highlight

    Point to the one value or comparison that matters: the target line, the record quarter, the outlier. Also give sort order and any categories to group, so the chart does not bury the point.

  6. Check every number in the result

    Compare the rendered labels, values, axis ranges, and totals with your source data before sharing. If something is off, ask for a revision of the same chart rather than starting over.

Copy and adapt

Prompt examples

Bar chart from pasted rows

Make a horizontal bar chart of Q3 revenue by region, sorted from highest to lowest. Units are USD thousands. Highlight EMEA as the fastest-growing region.

Region	Q3 revenue
North America	1840
EMEA	1320
APAC	960
Latin America	410

Why it works: The data is pasted as rows with a header, the unit is stated once, and the sort order and highlight are explicit.

Line chart with a target

Line chart of weekly p95 API latency in milliseconds for the last 8 weeks. Add a horizontal reference line at the 300 ms target and label the weeks that exceed it.

Week	p95 ms
W1	240
W2	255
W3	310
W4	290
W5	335
W6	280
W7	265
W8	250

Why it works: Time runs along the x-axis in order, the threshold is a stated value, and the annotation rule is spelled out instead of left to the model.

Share of a whole

Donut chart of this month's marketing spend by channel. Values are in USD and should total 50,000. Show percentages on the chart and put the total in the center.

Paid search: 18,000
Social: 12,500
Events: 9,000
Content: 6,500
Other: 4,000

Why it works: Giving the expected total lets you and Vizify catch a mistyped value, and a donut only makes sense when the parts sum to one whole.

Relationship between two measures

Scatter chart of ad spend (x-axis, USD) against sign-ups (y-axis) for these 10 campaigns. Label each point with the campaign name. Do not add a trend line.

[paste campaign, spend, sign-ups rows here]

Why it works: Both axes are named with units, point labels are requested, and the prompt rules out an added trend line you did not ask for.

Ask for a recommendation first

I want to show how our annual budget moved from last year's 2.4M to this year's 2.9M through five changes: +0.6M headcount, +0.2M tooling, -0.15M travel, -0.1M office, -0.05M other. Recommend the clearest chart type and then create it.

Why it works: When the question is clear but the shape is not, asking for a recommendation lets Vizify pick a format such as a waterfall before it generates.

Before you start

Current limitations

  • Data has to be pasted as text. CSV, XLSX, and PDF files cannot be uploaded, and Vizify does not fetch data from a URL or search the web for figures.
  • Vizify does not invent real-world data. It only generates example data when you ask for it, and labels it as example data.
  • Without Pro or a credit pack, an account gets two chart generations in total, and revising a chart uses the same allowance as creating one.
  • The chart is only as accurate as the values you supply. Check labels, totals, and axis ranges against your source before publishing.

Why the question comes first

The same table can produce very different charts. Quarterly revenue by region can be a bar chart comparing regions, a line chart showing each region’s trend, or a stacked bar showing how the total is composed. None of them is wrong, but only one answers the question you have. Writing that question into the prompt, such as “which region grew fastest this quarter”, lets Vizify choose the layout and the emphasis instead of guessing.

How Vizify turns data into a chart

Vizify has two chart engines and chooses between them by chart type. Mermaid handles the types it supports natively, including XY charts for bars and lines, pie charts, quadrant charts, radar charts, Sankey diagrams, and treemaps. Vizify Chart covers the formats Mermaid does not have, including area, scatter, donut, heatmap, histogram, funnel, waterfall, box plots, and business frameworks such as SWOT or a risk matrix. You can name either engine if you have a preference; otherwise Vizify picks the one that supports the chart you asked for, and tells you when neither does rather than substituting a different chart.

Either way, Vizify keeps your values, units, order, and labels as supplied, and it will not fill gaps with invented figures. If you want placeholder data for a mockup, ask for it and it will be labeled as example data.

Preparing data that charts cleanly

  • Put one header row first and keep one value per cell.
  • Use one unit per series and say what it is.
  • Write dates consistently (2026-07, 2026-08) so time sorts correctly.
  • Remove subtotal and total rows unless the chart is meant to show them.
  • Round to the precision the reader needs; six decimal places rarely help.

Revisions and the chart allowance

Chart generation is a gated action. Accounts without Pro or a credit pack get two chart generations in total, and both creating and revising a chart count, whichever engine produces it. Get the data and the question right in the first prompt, and batch several corrections into one revision request rather than sending them one at a time.

FAQ

Questions people ask

Can I upload a spreadsheet to make a chart?

Not as a file. Vizify uploads accept images, audio, and video only. Copy the cells you need from the spreadsheet and paste them into the prompt; they arrive as tab-separated rows.

How much data can I paste?

Paste only what the chart needs. A bar chart stays readable with about a dozen categories and a line chart with a few series. Summarize or aggregate large tables before pasting.

Which chart engine does Vizify use?

Vizify uses Mermaid for chart types it supports natively, such as bar and line charts, pie charts, and quadrant charts, and Vizify Chart for formats Mermaid does not have, such as scatter, donut, heatmap, funnel, and waterfall charts.

Will the AI make up numbers?

No. Vizify preserves the values, units, and labels you supply and only generates demonstration data when you explicitly ask for it, in which case it is labeled as example data.

Can I edit the chart after it is created?

Yes. Ask for a change to the same chart, such as a new sort order, a different highlight, or corrected values. Each revision counts toward the chart allowance on accounts without Pro or a credit pack.

What if I do not know which chart type to use?

Describe the question you want answered and ask Vizify to recommend a chart type before creating it. The chart tools on the Site are also organized by shape if you want to start from one.

Can Vizify pull numbers from a website or report for me?

No. Vizify does not browse the web or read PDF files. Collect the figures yourself and paste them with their source.

How many charts can I make without a paid plan?

Two chart generations in total, shared between Mermaid and Vizify Chart and between creating and revising. After that, charts need Vizify Pro or a credit pack.

Related

Keep going

Chart your numbers

Paste your data into the Bar Chart Maker and state the question.