A well-made chart can communicate in seconds what a table of numbers takes minutes to understand. Excel makes it straightforward to turn your data into a visual — but the default options are not always the best choice, and a few common mistakes can make charts misleading or hard to read. This guide walks through creating a chart from scratch and getting it to look professional.
Step One: Select Your Data First
Before you insert anything, select the data you want to chart. Include the headers — row and column labels — so Excel knows what to use for axis labels and the legend. A clean, well-structured table makes this much easier.
For example, if you have months in column A and sales figures in column B, select A1:B13 (including the header row). If you have multiple data series, select all the relevant columns at once.
Avoid selecting blank rows or totals rows that sit outside your data range — these confuse the chart.
Inserting a Chart
- With your data selected, go to the Insert tab on the ribbon.
- In the Charts group, you will see buttons for different chart types.
- Click the chart type you want, then choose a subtype from the dropdown.
- Excel inserts the chart on the same sheet as your data. You can move and resize it from there.
If you are unsure which chart type to use, click Recommended Charts. Excel looks at your data and suggests the most appropriate options — this is a good starting point for beginners.
Choosing the Right Chart Type
The chart type you choose has a big impact on whether the chart communicates clearly. Here is a practical guide:
Bar and Column Charts — for Comparing Things
Use these when you are comparing values across categories — sales by region, headcount by department, revenue by product. Column charts have vertical bars; bar charts have horizontal bars. Use horizontal bar charts when your category labels are long, as there is more room to display them.
Line Charts — for Trends Over Time
Line charts work best when you have a time series — monthly figures, weekly performance, daily temperatures. The connected line makes the trend obvious in a way that a column chart does not. Do not use a line chart for unrelated categories — the connecting lines imply a relationship that may not exist.
Pie Charts — for Proportions (Use Sparingly)
Pie charts show how parts make up a whole — for example, market share by company or budget split by department. They work well only when:
- You have five or fewer slices
- The proportions are noticeably different from each other
- Your audience only needs a rough sense of proportion, not precise values
When NOT to use a pie chart: if you have lots of small similar-sized slices, or if you need people to compare values precisely. In those cases, a bar chart is clearer. Never use a 3D pie chart — perspective distortion makes the slices look different sizes even when they are not.
Moving and Resizing a Chart
Click on the chart to select it. You will see handles (small squares) on the edges and corners. Drag a corner handle to resize. Drag the centre of the chart to move it. To snap it into position neatly, hold Alt while dragging — this aligns the chart to the cell grid.
Adding a Chart Title and Axis Labels
A chart without a title makes the reader guess what they are looking at. Click on the default “Chart Title” text and type a meaningful title. Be specific — “Monthly Revenue Jan–Dec 2024” is more useful than “Sales”.
To add axis labels, click the chart to select it, then click the + button that appears to the right (Chart Elements). Tick Axis Titles and edit the text that appears on each axis.
Changing the Data Range
If you need to add more data to a chart after creating it, right-click the chart and choose Select Data. Here you can add or remove data series, and adjust the range each series covers. You can also edit what the legend labels say.
Switching Rows and Columns
Sometimes Excel plots your data the wrong way around — for example, it uses months as separate series rather than along the horizontal axis. In Select Data, click Switch Row/Column to flip this. You may need to experiment to get the layout right.
Formatting Your Chart
Click any element of the chart to select it, then right-click for formatting options. You can:
- Change bar or line colours — right-click a data series and choose Format Data Series
- Change fonts — select a text element and use the Home tab
- Remove gridlines — click a gridline and press Delete
- Change the background — right-click the chart area and choose Format Chart Area
For a clean, professional look, use fewer colours (one or two is usually enough), remove unnecessary gridlines, and avoid heavy borders.
Adding Data Labels
Data labels show the actual value next to each bar, point or slice. Click the + button next to the chart and tick Data Labels. For bar charts, labels at the end of the bar work well. For pie charts, labels outside the slices are easier to read than labels crammed inside small slices.
Putting a Chart on Its Own Sheet
If your chart needs to stand alone — for a printed report, for example — you can move it to a dedicated chart sheet. Right-click the chart, choose Move Chart, then select New sheet and give it a name. The chart now occupies its own tab with no grid behind it, making it easier to work with and print.
Combo Charts: Two Chart Types in One
Sometimes you want to show two different data series that have different scales — for example, revenue as bars and profit margin as a percentage line. A combo chart handles this by putting one series on a secondary axis.
- Create a chart with both data series included.
- Right-click one of the series and choose Change Series Chart Type.
- In the dialog, set each series to its own chart type (e.g., Clustered Column for revenue, Line for margin).
- Tick Secondary Axis for the series that has a different scale.
- Click OK.
Common Chart Mistakes to Avoid
- 3D charts: avoid them entirely. The perspective makes values harder to read and can be misleading.
- Truncated y-axis: starting a bar chart axis at something other than zero exaggerates differences. Always start at zero for bar and column charts.
- Too many series: more than four or five series in one chart becomes unreadable. Split into multiple charts if needed.
- Missing labels: always include a title, axis labels, and a legend if you have more than one data series.
- Pie charts with too many slices: if you have more than five categories, use a bar chart instead.
