Many times subscribers have written to me to inquire how to change the default color of charts and graphs in MS Excel. The reasons are myriad. Some folks want to use the company logo or school color scheme and others just want something a little more “in your face.”
In MS Excel 2007 you will find that Excel uses Themes to fill your charts and graphs, so it would follow that you can create a custom theme with your personal choice of colors.
To do this:
- Click on the Page Layout tab of the Ribbon.
- Click the Colors drop-down menu in the Themes group.
- Select Create New Theme Colors.
- Click the color element you would like to change.
- Select the new colors you would like to use.
- Give your new Theme an intuitive name so you will recognize it the next time you would like to use it.
- Save your new Theme.
- To make these your default colors, perform the above steps in a blank workbook.
- When you have finished your selections, click on Save As and navigate to your templates folder.
- Change the Save as Type to Template.
- Name the file: book.xltx and save it.
Now you have saved yourself time and keystrokes because all your future charts and graphs will look like the selection you have made and you will not have to do it again!