MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Saving Pivot Chart Formats


Posted by Jeff on February 13, 2002 2:14 PM

When I create a pivot chart, default colors are assigned to the data series. I can change the colors to what I want, but whenever I manipulate the chart at all, the colors return back to the default. How can I correct this problem? Thanks.


Posted by Mark W. on February 13, 2002 2:51 PM

Before you apply any formatting make sure that
all PAGE fields are set to "(All)" and that you
have Enabled Selection. The latter is accomplished
by right-clicking on your PivotTable and choosing
Select | Enable Selection from the popup menu.
Note: The Enable Selection icon should appear
depressed -- look closely!!!