Make a Chart in Excel: Column, Bar, Line and Pie

To make a chart in Excel, select your labels and numbers, open the Insert tab and pick a chart type. The hard part isn't the clicks; it's choosing the chart that answers your question and keeping out the things that distort it, like a total row. This guide covers column, bar, line and pie charts step by step, for Windows and Mac.

How to make a chart in Excel step by step#

A chart needs two things: labels (the categories) and numbers (the values). Put them in neighbouring columns with a header on each.

1. Select A1:B5, headers included. (Or click any one cell inside the data and Excel selects the block.)
2. Go to Insert > Recommended Charts and pick one of Excel's suggestions, or choose a type directly from the Charts group: Insert Column or Bar Chart, Insert Line or Area Chart, or Insert Pie or Doughnut Chart.
3. Click the chart type you want. The chart appears on the sheet.

Two Windows shortcuts make it even faster: Alt+F1 inserts the default chart (a column chart) next to your data, and F11 puts it on a new chart sheet of its own. On a Mac, use the Insert tab.

Excel uses the header Sales as the chart title and the regions as the axis labels. Drag the chart's edge to move it, or a corner to resize it.

Which chart type should you use?#

Pick the chart from the question you're answering, not from what looks impressive.

Column and bar charts#

Use these for comparing categories: sales by region, headcount by department, tickets by status. Sort the data first, largest to smallest, and the bars line up in order, which makes the ranking obvious. Our guide to sorting data in Excel shows how.

Line charts#

Use a line chart when the labels are in time order: months, quarters, years. Put the dates or month names in the first column, oldest at the top. A line chart of unordered categories (like regions) suggests a trend that doesn't exist.

Pie charts#

Use a pie only when the values are parts of one total and there are just a few of them. With many slices, or slices of similar size, the eye can't compare angles well, so a bar chart is clearer. Each slice is that part's share of the total, which is exactly what =B2/SUM($B$2:$B$5) calculates. Try it in the exercise on this page.

Add titles, data labels and axis titles#

A chart should make sense without anyone reading the sheet. Three additions do most of the work.

On Windows, click the chart and then the + button (Chart Elements) at its top-right corner. On a Mac, or as an alternative on Windows, use Chart Design > Add Chart Element. Then:

• Chart Title: click the title and type a clear one, like "Sales by region, 2026". A title that states the point ("North sold the most") is even better.
• Data Labels: put the exact number on each bar or slice. On a pie chart, labels with percentages help.
• Axis Titles: name the units, such as "Sales ($)", when they aren't obvious.

The brush button next to + (Windows) changes the style and colors; you'll find the same options on the Chart Design tab. Keep it simple: one color for a single series reads better than a rainbow.

Change the data or the chart type#

You can change almost everything after the chart exists. Click the chart, then use the Chart Design tab:

• Change Chart Type switches a column chart to a bar or line chart without starting over.
• Switch Row/Column swaps what's on the axis and what's in the legend. Use it when your chart groups the wrong way.
• Select Data lets you add or remove series and fix the axis labels.
• Move Chart moves it to its own chart sheet.

Common chart problems and how to fix them#

Most chart problems come from what you selected.

1. The total is a giant bar. You included the Total row. Select only the detail rows, or delete the total from the chart's data range. A chart of the parts already shows how they add up.
2. Years show up as a data series. Year numbers like 2024 and 2025 look like data to Excel. Clear the header cell above the years, so the top-left cell of your selection is empty, and Excel uses them as labels. You can also fix it with Select Data.
3. Blank or zero bars. Numbers stored as text plot as zero. Convert them to real numbers.
4. The chart doesn't show new rows. A normal range is fixed. Convert the data to an Excel table with Ctrl+T before charting, and the chart grows with the table.

Make a chart from a summary: SUM and pivot tables#

Charts work best on summarised data, not on hundreds of raw rows. If you have a list of individual orders, total them by category first.

With formulas, use SUM for each total, or SUMIF to total by category. If formulas are new to you, start with how to write your first Excel formula. With a pivot table, drag the category to Rows and the amount to Values, then choose PivotTable Analyze > PivotChart. A pivot chart updates when you refresh the pivot, and its field buttons let you filter the chart directly.

Clean charts appear in most office reporting, from the weekly summaries in admin and office jobs to the monthly packs in finance and accounting roles.

Practise it#

Start with the exercise on this page: calculate a region's share of the total, the number a pie slice shows. Then practise adding up ranges with SUM, and build a pivot table in a live spreadsheet to summarise raw data into chart-ready totals.