A new version of this post has been published here: http://easy-excel.com/?p=404
Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than in, say Excel 2003, but you still need to make a few changes if you want them to look professional.
These are the 5 things you need to do to make you Excel chart look good
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
First, let’s make a chart. To make a chart, select the table, go to the Insert ribbon and choose a chart. Avoid the 3D charts – they never look as cool as you might think.
This is what Excel gives you:
…and this is what it looks like after a 2 minute makeover:
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:
a) Change the wording, e.g. Monday to Mon, Tuesday to Tue, etc. Change it in the table, not in the chart!
b) Make the chart wider. Point your mouse on the right edge of the chart and drag it sideways. That’s what I am going to do here.
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.
4. Make the bars wider
Double-click on one of the bars to open the Format Window. Change Gap Width to 50.
5. Add Data Labels
Right-click on one of the bars and choose Add Data Labels.
Then, click somewhere on the chart and go to the Layout ribbon. Choose Data Labels => Inside End. 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: