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.

For more tips and tricks and helpful Office columns, visit Projectwoman.com

Helen Bradley

Related posts:

  1. Excel – print charts in black and white
  2. Excel – Replace charts with pictures
  3. Excel multi color column charts
  4. Multi colored Excel charts
  5. Pattern fills for your Excel 2007 charts