How to make a chart in Excel that answers the right question

In short: select your table including the headers, go to Insert > Charts and pick a type. Use columns or bars to compare, a line to show a trend over time and a pie to show parts of a whole.

Try it now

The table holds six months of revenue and orders. Build a column chart of revenue per month by choosing the chart type, the labels and the data series next to the sheet. The chart is drawn as you go.

Task Create a column chart that shows the revenue per month, with the months on the axis.

	A	B	C
1	Month	Revenue $	Orders
2	Jan	18400	42
3	Feb	21300	47
4	Mar	19800	45
5	Apr	24600	53
6	May	23100	50
7	Jun	26900	58

Which chart for which question?

Put the question into words first. The chart type nearly always follows from it.

Question	Chart type	Example
Which one is bigger?	Column chart	Revenue per store
Comparison with long names	Bar chart (horizontal)	Revenue per product or sales rep
How does a value change over time?	Line chart	Revenue from January to December
What share does each part have?	Pie chart	Share of revenue per region

Column and bar charts are the same idea turned on its side. Switch to bars as soon as the labels get long, because long names under columns end up tilted or cut off. A pie chart only works with a single data series and a handful of slices that add up to a meaningful whole.

How to insert a chart

1. Select the data with its headers, for example A1:B7. The column with months or names becomes the labels, the number columns become data series.
2. Go to Insert and pick a type in the Charts group, such as Column or Line. Not sure which? Recommended Charts shows suggestions with a preview, and the All Charts tab lists every type.
3. Click the finished chart and the Chart Design tab appears. Add Chart Element, Select Data and Switch Row/Column handle everything else.

For a quick start, press Alt+F1: Excel builds a chart of the default type from your selection right away. Change it afterwards with Change Chart Type.

Selecting the right data

When the columns you need are not next to each other, select the label column first, then hold Ctrl and select the number column. That way only revenue goes into the chart, not the order count sitting between them.

Picked too much or too little? Right-click the chart and choose Select Data. On the left you see Legend Entries (Series), on the right Horizontal (Category) Axis Labels. Add or remove series there, or edit their ranges. If your months show up in the legend instead of along the axis, click Switch Row/Column.

Chart title and axis titles

An unlabeled chart leaves readers guessing whether they are looking at dollars, units or percent. Use Chart Design > Add Chart Element > Axis Titles to label the vertical axis, for example "Revenue in $". Write the chart title as a finding: "Revenue up since April" tells the reader more than "Revenue 2026". You only need a legend when there is more than one series.

Another exercise: shares in a pie chart

This table lists revenue for five regions across two years. The question is each region's share of 2026 revenue, so think about which column belongs in the pie.

Task Management wants to see what share of total 2026 revenue each region brings in. Create the chart that answers this.

	A	B	C
1	Region	Revenue 2025 $	Revenue 2026 $
2	North	412000	446500
3	South	538000	512300
4	East	297000	331800
5	West	365000	389200
6	Central	184000	201400

Two data series in one chart

Plan versus actual, last year versus this year: putting two series in one chart makes the gap visible straight away. Select the label column and both number columns, and Excel draws two lines or pairs of columns with a legend. This works well as long as both series are on a similar scale.

Task Show in a chart how plan and actual revenue develop from January to June, so it is easy to spot the months where actual falls short of plan.

	A	B	C	D
1	Month	Plan $	Actual $	Variance $
2	Jan	52000	49800	-2200
3	Feb	54000	55300	1300
4	Mar	56000	54100	-1900
5	Apr	58000	59700	1700
6	May	60000	61800	1800
7	Jun	62000	60400	-1600

Different scales: the secondary axis

Revenue in the tens of thousands and orders in double digits do not share an axis well: the orders end up as a flat line along the bottom. The fix is a second value axis on the right. Click the chart, choose Chart Design > Change Chart Type, then Combo. Tick Secondary Axis for the smaller series and show it as a line over the revenue columns. Give both axes a title, or someone will read the orders off the dollar scale.

Common mistakes

A pie with too many slices

With twelve months or twenty products, a pie turns into a fan of thin wedges nobody can compare. Use a bar chart sorted by size instead, or group the small items into "Other". And a pie is never the right choice for a trend over time.

The totals row is in the selection

Include the "Total" row and it becomes the tallest column, squashing everything else. In a pie it is worse: the total takes up exactly half the circle. Select the individual values only.

Dates stored as text

If your dates are text, Excel treats them like any other label and spaces them evenly, whether one day or one month lies between two points. With real date values Excel can use a date axis instead. See the date functions lesson for turning text into proper dates.

Years plotted as a series

When the first column holds 2023, 2024, 2025, Excel sees numbers and draws the years as their own columns. Open Select Data, remove the series with the years and enter that range on the right as the axis labels instead.

Recommended Charts and sparklines

Recommended Charts looks at your selection and suggests types that suit it. A good start, but it cannot know what your chart should say. Sparklines are tiny charts inside a single cell, handy for showing a trend at the end of every row in a table. You find them under Insert > Sparklines as Line, Column or Win/Loss.

Chart commands in German Excel

The names you will see in a German copy of Excel:

English	German
Insert > Charts	Einfügen > Diagramme
Recommended Charts	Empfohlene Diagramme
Column, Bar, Line, Pie chart	Säulen-, Balken-, Linien-, Kreisdiagramm
Chart Design / Select Data	Diagrammentwurf / Daten auswählen
Add Chart Element > Axis Titles	Diagrammelement hinzufügen > Achsentitel
Switch Row/Column	Zeile/Spalte wechseln
Secondary Axis	Sekundärachse

Which Excel versions have these features?

Charts are part of every current version. Microsoft documents the steps for Excel 2016, 2019, 2021, 2024 and Microsoft 365, on Windows and Mac, and Excel for the web creates charts from the Insert tab as well. In older versions the tab is called Design rather than Chart Design, with the same commands.

Frequently asked questions