Chart Types & When to Use Each¶

A chart turns numbers into a picture the eye understands instantly. The skill isn't making charts — it's choosing the right one.

A set of business charts: bar, line and pie

Match the Chart to the Message¶

You want to show	Use
Compare categories	Column / Bar
Trend over time	Line
Parts of a whole	Pie / Doughnut (≤5 slices)
Relationship between 2 values	Scatter (XY)
Cumulative total over time	Area
Distribution	Histogram
Progress to a goal	Bar / Gauge

Caution

Avoid pie charts with many slices — the eye can't compare angles well. A bar chart is almost always clearer. And never use 3-D charts for analysis; the perspective distorts the values.

Creating a Chart¶

1.Select your data including headers.
2.Insert tab → pick a chart type (or use Recommended Charts).
3.The chart appears; drag to position it.

| Month | Sales |        →   a Line chart of Sales over the months
| Jan   | 1200  |
| Feb   | 1500  |
| Mar   |  900  |

Recommended Charts¶

Not sure? Insert → Recommended Charts previews the types Excel thinks fit your data best. A great starting point for beginners.

Anatomy of a Chart¶

Element	What it is
Chart Title	What the chart shows
Axes (X/Y)	The two scales
Axis Titles	What each axis measures
Legend	Which series is which color
Data Labels	Exact values on the bars/points
Gridlines	Faint guides for reading values

Click the + button beside a selected chart to toggle any of these on/off.