Changing Excel Chart Defaults

Here’s a neat trick that will save you time and frustration when creating charts – save your charts as templates and re-use the settings again in the future.

On the left is an example of a chart using Excel’s defaults. But this chart has too many problems: the bars are too far apart, they are all the same color (where do you want me to focus?), the x-axis has an unecessary maximum of 1,200 with frequent division by 200, there’s unnecessary title, legend and vertical lines.

I want to adjust all this, so I manually correct this to the chart on the right. Note the gray bars are intentionally neutral. I will later highlight the important bars by adding color.

Excel default

Manually updated

You could update the chart each time by manually changing the fill color, deleting the extra elements and so on. But in PowerPoint 2007 there’s a better way: save the second chart as a template so you can re-use it again and again. Here’s how.

Now I have a neutral canvas on which to paint my picture. Maybe my message is look at sales in Toronto! I add some color and bold text and my message is clear – and in half the time.

About the author: Bruce Gabrielle is author of Speaking PowerPoint: the new language of business, showing a 12-step method for creating clearer and more persuasive PowerPoint slides for boardroom presentations. Subscribe to this blog or join my LinkedIn group to get new posts sent to your inbox.