How to Make a Chart in Excel

To make a chart in Excel, select your data including the headings, go to the Insert tab, and choose a chart type such as column, line or pie. Excel draws the chart on the same sheet in one click. You then add a title and labels so anyone can read it at a glance. A good chart shows a pattern that a table of numbers hides.

Pick the right chart

Choosing the chart is half the job:

A pie chart only works with a handful of categories that add up to 100%. For anything else, a column chart is usually clearer.

Step by step: make a column chart

1. Select your data, including the row and column headings.
2. Go to the Insert tab.
3. In the Charts group, click the column chart icon and pick Clustered Column.
4. The chart appears on your sheet. Drag it to an empty area.

Add a title and labels

A chart without labels is useless. With the chart selected:

1. Click the + button that appears at the top-right of the chart (Chart Elements).
2. Tick Chart Title and type a clear name, like "Monthly Sales 2026".
3. Tick Data Labels to show the exact numbers on each bar.
4. Tick Axis Titles if the axes aren't obvious.

Worked example (monthly sales)

Select all six cells and insert a Clustered Column chart. You instantly see February was the best month, which is much harder to spot in the table. Add the title "Monthly Sales" and data labels, and it's ready for a report.

Change or restyle the chart

• Click the chart, then use the Chart Design tab to change colours or switch chart type.
• Change Chart Type lets you swap a column for a line without redrawing.
• Switch Row/Column flips what's on the bottom axis if the chart looks wrong.

Pro tips

• Keep it simple: one clear message per chart. Remove gridlines and extra decoration that don't help.
• Sort your data before charting a column chart so the bars run in a sensible order.
• Copy a finished Excel chart and paste it straight into Word or PowerPoint for a report.

Common mistakes

• Selecting numbers without headings. Include the labels so the chart has axis names, not "Series 1".
• Using a pie chart for too many slices. More than five or six slices becomes unreadable. Use a column chart instead.
• No title. A reader shouldn't have to guess what a chart shows. Always add a title.

Key takeaways

• Select data with headings, then Insert ▸ chart type.
• Column for comparisons, line for trends, pie for parts of a whole.
• Use the + button to add a title and data labels.
• Charts paste directly into Word and PowerPoint.

Practice task

Make a small table of five months and their expenses. Create a column chart, give it a title, and turn on data labels. Then change it to a line chart and notice how the story changes from comparison to trend.

Charts are how you turn data into a story managers understand. Build full reporting skills in the ADCA program at HCI.