How to Create Charts in Excel

Introduction

You have six months of revenue data across three product lines and need to show your team where growth is coming from. The raw numbers are all in the spreadsheet, but a chart makes the trends obvious at a glance. Most situations call for one of four types: column, line, pie, or scatter.

The Dataset

Here's a monthly revenue table by product line:

	A	B	C	D
3	Month	Desks	Chairs	Lamps
4	Jan	4200	2800	900
5	Feb	4500	3100	1100
6	Mar	5100	3400	1000
7	Apr	5400	3200	1200
8	May	5800	3600	1300
9	Jun	6200	3900	1400

Six months, three products. Desks generate the most revenue and grew every month. Chairs are steady. Lamps are the smallest line but climbing.

Column Charts

Column charts compare values side by side. They're the default chart type in Excel and the right choice when you want to show how values differ across groups.

Select the data range A3:D9 (headers through the last row of data).
Go to Insert > Charts > Clustered Column (the first option under the column icon).
Excel inserts a chart with months on the horizontal axis and revenue on the vertical axis. Each product gets its own colored bar.

The chart shows three bars per month. Desks tower over the other two in every period, and the bars grow taller from left to right as revenue increases. January's Desks bar sits at 4,200 while June's reaches 6,200.

To switch to a stacked column chart, click the chart, go to Chart Design > Change Chart Type, and choose Stacked Column. Instead of three separate bars per month, the values stack on top of each other. The total height of each stack shows total monthly revenue, and the colored segments show how much each product contributes.

Key takeaway: Use clustered columns when you want to compare individual values across categories. Use stacked columns when the total matters more than the individual parts. Both start from the same data and take one click to switch between.

Line Charts

Line charts show trends over time. Where a column chart emphasizes the size of each value, a line chart emphasizes the direction.

Select A3:D9.
Go to Insert > Charts > Line (the line icon).
Excel draws one line per product across the six months.

The Desks line climbs steadily from 4,200 to 6,200. Chairs rise more gradually from 2,800 to 3,900, and Lamps hover near the bottom but trend upward. The slopes tell you immediately which product is growing fastest without comparing individual numbers.

Line charts work best with time-series data where the horizontal axis represents sequential periods. If your categories have no natural order (like regions or product names), a column chart is a better fit.

Pie Charts

Pie charts show how parts make up a whole. They work best with a single set of values that add up to a meaningful total.

To show each product's share of total revenue across all six months, first calculate totals. Desks total 31,200, Chairs total 20,000, and Lamps total 5,900. The grand total is 57,100.

Set up a small summary:

	F	G
3	Product	Total Revenue
4	Desks	31200
5	Chairs	20000
6	Lamps	5900

Select F3:G6.
Go to Insert > Charts > Pie (the pie icon).
Excel draws a circle divided into three slices.

Desks take up more than half the pie (55%). Chairs account for 35%, and Lamps make up the remaining 10%. The chart makes Desks' lead obvious in a way that three numbers in a table don't.

Pie charts lose their effectiveness with more than five or six slices. Too many small slices become hard to read and impossible to label cleanly. For larger category sets, a sorted bar chart tells the story better.

Scatter Charts

Scatter charts plot two numeric variables against each other to reveal relationships. Unlike the other chart types, both axes represent numbers rather than categories.

Suppose you also track monthly advertising spend and want to see whether higher spend correlates with higher Desks revenue:

	F	G
10	Ad Spend	Desks Revenue
11	500	4200
12	600	4500
13	800	5100
14	750	5400
15	900	5800
16	1000	6200

Select F10:G16.
Go to Insert > Charts > Scatter (the icon with dots).
Excel plots each month as a point, with Ad Spend on the horizontal axis and Desks Revenue on the vertical axis.

The dots trend upward from left to right: months with higher ad spend produced higher revenue. To add a trend line, click any data point, right-click, and choose Add Trendline. Select Linear for a straight line of best fit. The trendline helps you see the relationship even when individual points don't line up perfectly.

Formatting a Chart

Every chart Excel creates starts with default formatting. A few changes make it clearer.

Chart title. Click the default title text and type a descriptive name. "Monthly Revenue by Product" is better than "Chart Title."

Axis labels. Click the chart, then go to Chart Design > Add Chart Element > Axis Titles. Add a vertical axis title like "Revenue ($)" so readers know the units.

Data labels. To show exact values on the chart, go to Chart Design > Add Chart Element > Data Labels. For pie charts, choose More Options and check Percentage to display the percent each slice represents instead of raw numbers.

Changing colors. Click any data series in the chart (like the Desks bars), right-click, and choose Format Data Series. Under Fill, pick a new color. For a coordinated palette across all series, click the chart and use Chart Design > Change Colors.

Moving and resizing. Drag the chart to reposition it on the sheet. Drag any corner handle to resize. To move a chart to its own sheet, right-click the chart and choose Move Chart, then select New sheet.

Things to Know

Source data. Charts update automatically when the cells they're built from change. But if you add rows below the original range, the chart won't include them until you expand the source. Converting your data to an Excel Table (Ctrl + T) handles this automatically.
Non-contiguous ranges. To chart columns that aren't next to each other, hold Ctrl while selecting each range before inserting the chart.

Conclusion

Column, line, pie, and scatter charts cover most data visualization needs in Excel. Pick column for comparisons, line for trends, pie for proportions, and scatter for relationships between two variables.

For summarizing data before you chart it, see our guide on pivot tables. To highlight key values directly in cells without a separate chart, check out our guide on conditional formatting.