Lesson 5 of 7
Charts & reports from a prompt
5 min read
You've got a tidy table of numbers and a meeting in ten minutes. You need a chart, not a spreadsheet lesson. So you just ask for one.
A table in, a chart out
Once AI can read your table, a chart is one sentence away. Ask for it — "chart this" — and it works out which column is a label and which is a value, then draws it. The same numbers can become bars to compare, a line to show a trend, or a pie to show a share. You pick the shape that fits the story; the numbers stay the same underneath.
The chart type isn't decoration — it answers a question. Bars compare, a line shows change over time, a pie shows parts of a whole.
From chart to report
It doesn't stop at one picture. Ask AI to "summarise what this chart shows" and it writes the caption for you — "sales rose steadily, peaking in Q4." String a few of those together and you've got the start of a report, built from the same table you began with.
AI picks a chart, but it can pick a misleading one — a pie of things that don't sum to a whole, an axis that exaggerates. Glance at whether the shape actually fits the question.
The shape of it
- —Ask for a chart and AI reads the table and draws it — no chart wizard.
- —Same numbers, different shapes: bars compare, a line trends, a pie splits.
- —It can caption the chart too, turning a picture into a mini report.
You've got monthly sales for the past year and want to show they're trending up. Which chart fits, and how do you get it?
Continue in the app
Take the whole AI for Spreadsheets course — tracked
Get your personalized path, progress and streaks in the app — this lesson and every next one, in order.