Charts & Graphs
Not a function, a visual. Turns a table into a picture: a bar chart, a line chart, or a pie chart, depending on what question the data is actually answering.
The hardest part of charting in Excel isn't finding the Insert Chart button, it's picking the right chart type for what the data is actually supposed to show. Comparing a handful of categories side by side, regions, reps, products, calls for a bar chart. Tracking one number across consecutive time periods calls for a line chart, so the trend itself is visible rather than buried in a row of separate bars. Showing how parts add up to one meaningful whole calls for a pie chart, and only that case: a pie implies the slices genuinely sum to something real, which a trend or an open-ended comparison doesn't.
Whenever the raw data has more than one row per category, group and aggregate first using the same Sum/Average/Count/Min/Max vocabulary a pivot table uses, before the chart is built on top of it.
Syntax
| Argument | Description |
|---|---|
| Category (X axis) | Required. The field each bar, point, or slice represents, e.g. Region, Month, Department. |
| Value (Y axis) | Required. The numeric field being charted, plus an aggregation (Sum, Average, Count, Min, Max) whenever more than one row shares a category. |
| Chart type | Required. Bar, Line, or Pie, chosen for what the data means, not personal taste. |
A real example: a sales trend that a bar chart would hide
Monthly user counts, where the point is the direction of travel, not just the three raw numbers:
A bar chart of the same three numbers would show the same values, but a connected line makes the upward (or downward) movement across months the actual thing a reader notices first.
Worked examples
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | West | 620 |
| 3 | East | 300 |
| 4 | South | 150 |
| A | B | |
|---|---|---|
| 1 | Month | Users |
| 2 | Jan | 1200 |
| 3 | Feb | 1350 |
| 4 | Mar | 1290 |
(a bar chart would show the same numbers but hide the trend)
Common mistakes
- Picking a pie chart when there's no real "whole" the slices add up to. A trend or an open-ended comparison doesn't belong in a pie.
- Charting a trend over time as a bar chart instead of a line. The numbers are the same, but a line chart makes the trend itself the point.
- Forgetting to group and aggregate first when the raw data has more than one row per category. A chart summarizing 6 rows into 3 categories still needs that step, the same way a pivot table does.
Related functions
Try it yourself
A free, graded practice exercise using this exact function: instant feedback, no signup required.
Practice charts →