Note: If you try to create a new custom set of Colors with the same name as an existing one, Excel automatically adds a number 1 at the end of the name you enter. The location of the Theme Colors folder may vary, but it is usually located here:Ĭ:\Users\ \ AppData\ Roaming\ Microsoft\ Templates\ Document Themes\ Theme Colors, where is your Windows login name. See more about changing the default colors that Excel uses for chart series.Ī custom set of Colors is saved as a *.xml file in the Theme Colors folder and automatically added to the top of the Colors list in the Custom section. Click the Save button to save a created custom set of Colors.Type a name for the new Theme Colors in the Name field,.Assign a color to every of the 12 color placeholders (see how to apply a solid color) you want to change,.
