5 Easy Steps to Make Your Excel Charts Look Professional

Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than they did before, but you still need to make a few changes if you want them to look good enough for a presentation.

These are the 5 things you can do to make your Excel chart look professional:

  1. Get rid of the legend.
  2. Make sure the X-axis labels look ok
  3. Make the gridlines lighter.
  4. Make the bars wider (if it’s a column chart)
  5. Add Data Labels
EasyExcel_20_1_Professional Excel Chart

First, let’s make the chart. To make a chart, select the data table, go to the Insert ribbon and choose a chart. Avoid the 3D charts – they never look as cool as you would hope, and they usually turn out to be more difficult to read.

This is the default column chart design in Excel:

EasyExcel_20_2_Professional Excel Chart

…and this is what it looks like after a 2 minute makeover:

EasyExcel_20_8_Professional Excel Chart

The 5 steps to a professional looking chart

EasyExcel_20_3_Professional Excel Chart

1. Get rid of the legend.

Most charts have only one data series, so the chart title gives you all the information you need.

Click on the legend and hit the Delete key.

2. Make sure the X-axis labels look ok.

In our example, the words are too long, and the alignment looks terrible. There are two ways to solve this problem:

  1. Change the wording, e.g. Monday to Mon, Tuesday to Tue, etc. Change it in the table, not in the chart!
  2. Make the chart a little wider. Point your mouse on the right edge of the chart and drag it sideways. That’s what I am going to do here.
EasyExcel_20_4_Professional Excel Chart
EasyExcel_20_5_Professional Excel Chart

3. Change the gridline colour to light grey.

Double-click on one of the gridlines to open the Format Window. Choose Solid Line and select a light colour. If you want to remove the gridlines all together, simply click once on one of them and hit the delete key.

EasyExcel_20_6_Professional Excel Chart

4. Make the bars wider.

Double-click on one of the bars to open the Format Window. Change Gap Width to 50.

EasyExcel_20_9_Professional Excel Chart

5. Add Data Labels.

Click somewhere on the chart and go to the Layout ribbon. Choose Data Labels > Inside End. Then, right-click on one of the data labels and change the font colour to white.

If you want, you can make the whole worksheet look a little nicer by changing the background colour to white.

Here’s our result again, after our five step makeover:

EasyExcel_20_8_Professional Excel Chart

If you’re happy with this design, you can save it as a template. Click on the chart, go to the Design ribbon and choose Save as Template. The next time you make a chart, all you have to do is to select one cell in your data table and press Alt + F1.

Other tutorials:

Are you using a non-English version of Excel? Click here for translations of the 140 most common functions in 17 different languages:

Portuguese (Brazilian)
Portuguese (European)

Leave a Reply

Your email address will not be published. Required fields are marked *

− two = 7