Multi colored Excel charts

It isn't always the case that you want to chart multiple series of data on a single chart. Sometimes you only have a single series and Excel, by default, plots all the bars or columns so they are colored identically. Boring!

Luckily, in Excel 2007 a solution is at hand. Simply select and right click the series and choose Format Data Series > Fill > Vary Colors by Point. Excel colors each bar a different color. Best of all, the colors are linked to themes so you can change the colors by changing the Theme - the theme tools are on the Page Layout tab.

So, no more boring single color charts - ever - please!

Excel charts - create an overlapping series

Sometimes an Excel chart will look better if your series overlap - this might be the case when you are comparing data from two years and where you want to show how the values have increased from one year to the next.

To make your series overlap in Excel 2007, select one series, right click and choose Format Data Series. Click the Series Options and decrease the Gap Width (it closes the chart up nicely) and incease the Series Overlap. Set the Series Overlap to around 60% and the Gap Width to around 30% for a good result. This is particularly useful when you are using images in place of colors for the bars of your chart but works in almost any situation.