Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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.

Re: Saving Pivot Chart Formats

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!!!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.