I created a new theme with the set of colors I need. However, when I make a pivot table it's using a colors that aren't in the theme. They aren't the standard colors either. I also used the Design tab in the Pivot Table Tools menu to make a new Pivot table style. Unfortunately, it doesn't "stick;" I have to remake the style in every new workbook, even when I specify it as the default.
I've attached an example. I created the style I'd like to use, but didn't apply it.
My question - Where is the pivot table coming up with its colors? Can I change the default?
In Excel 2003, you could change the standard colors. I don't see how to do that in 2007.
Thanks for your help!
Themes and pivot table colors
-
- StarLounger
- Posts: 59
- Joined: 08 Feb 2010, 14:26
- Location: Lawrence, KS
Themes and pivot table colors
You do not have the required permissions to view the files attached to this post.
Cathy
-
- 5StarLounger
- Posts: 826
- Joined: 24 Jan 2010, 15:56
Re: Themes and pivot table colors
In the Pivot table styles list,right-click your custom one and choose Set Default.
It will only apply to this workbook, but you could set it up in a template workbook and use that for all new workbooks.
It will only apply to this workbook, but you could set it up in a template workbook and use that for all new workbooks.
Regards,
Rory
Rory
-
- StarLounger
- Posts: 59
- Joined: 08 Feb 2010, 14:26
- Location: Lawrence, KS
Re: Themes and pivot table colors
Of course! Thanks so much. Any clue where the odd colors are coming from? They change when you change the theme. Very strange.
Cathy
-
- 5StarLounger
- Posts: 826
- Joined: 24 Jan 2010, 15:56
Re: Themes and pivot table colors
It appears to use whatever the Accent1 cell style is set to.
Regards,
Rory
Rory