How to Make Charts From Excel Data With AI

Most bad charts aren't badly drawn. They're drawn from the wrong table. Select 5,000 order rows, hit Insert → Chart, and Excel obligingly plots 5,000 points. The fix is never in the chart options; it's in the step before — aggregating the rows into the dozen numbers the chart is actually about.

That's what an AI assistant does well: it aggregates first, then plots. This guide covers which chart answers which question, how to ask for it, and what to check when it appears.

Charts answer one of four questions

If your question doesn't fit one of these, you probably want a table. "Show me every order" is a table. "Which orders are unusually large" is a table with a sort. Charts compress; tables list.

Step 1: get the aggregated numbers first

Every chart is drawn from a small table: one row per bar, per point, per slice. Ask for that table, in words:

• "Total revenue by region" → 4 rows → bar chart.
• "Total revenue per month in 2024" → 12 rows → line chart.
• "Share of revenue by product" → 3 rows → pie chart.

In ChatExcel, asking the question gives you the table; adding "chart that" or "as a chart" plots it. The assistant aggregates with a query, so a 40,000-row export becomes 12 points, not a smear.

Step 2: ask for the chart

Phrasing that works:

• "Chart revenue by region." (assistant picks bar)
• "Line chart of monthly revenue."
• "Pie chart of revenue share by product."
• "Compare units and revenue by product." (two series, bar)

Phrasing that produces something confusing:

• "Chart the data." — chart what?
• "Chart all orders by date." — that's a scatter of thousands of points; ask for a monthly or weekly total instead.

Step 3: read it like an analyst

When the chart appears, check three things:

1. The number of points is small and matches your grouping. Four regions → four bars.
2. The units make sense. If the y-axis says 10,000 and your business does $10M a month, something's been divided or a column was mistaken for another.
3. The table view agrees. ChatExcel charts have a table toggle; the numbers should match what the answer text said. If a total row snuck in as a category, you'll see a bar labeled "Total" towering over the rest — remove it from the data or ask the assistant to exclude it.

Choosing between bar and line

The rule that resolves most arguments: line for time, bar for everything else. Months, weeks, and years are ordered and continuous — a line shows the shape. Regions and products are not ordered — a bar lets the reader compare heights without implying a sequence.

Two exceptions. A bar chart of months is fine when the point is comparing individual months ("December vs. January") rather than seeing a trend. And a line through categories is always wrong.

When to use (and not use) a pie chart

Pie charts answer exactly one question: what fraction of the whole is each part? They work with two to five slices and fail past six because humans compare angles badly. If you have eight products, chart the top five as slices and the rest as "Other," or use a bar chart sorted by size — it answers the share question just as well and the comparison question better.

Multiple series

"Units and revenue by product" is two measures on one chart. Bars side by side work when the scales are similar. When they aren't — units in the hundreds, revenue in the thousands — the smaller series flattens into nothing. Don't reach for a secondary axis; it makes two charts pretend to be one. Ask for two charts, or index both to 100.

Taking the chart back to Excel

If the chart needs to live in the workbook, ask "how do I build this chart in Excel?" The recipe is always the same shape:

1. Build the aggregated table — a pivot table (Region in Rows, Revenue in Values) or a column of SUMIFS.
2. Select that small table, Insert → Recommended Charts.
3. Delete the legend if there's one series; sort bars by value; label the axis with the unit.

The assistant will write the SUMIFS or describe the pivot layout against your actual column names.

Try it

Upload a sheet and ask "chart revenue by region." Then ask "what about by month?" — the conversation keeps the context, so you can iterate on a chart the way you'd talk through it with a colleague.