Controlling the way pivot charts are formatted in Excel 2000?

[davidd31415]

Is there a way to control how pivot charts are formatted when fields are changed?

I'd like to prevent certain colors from being used and increase the size of markers, among other things...

Each time I reconfigure the pivot chart (show more or less data, rearrange the fields) the chart defaults back to initial settings.

 

[dianemarie]

Hi David, straight from Help. Diane

Click the PivotTable report.

On the Options tab, in the PivotTable group, click Options.
The PivotTable Options dialog box is displayed.

Click the Layout & Format tab, and then under the Format section, do one of the following:
--To save the PivotTable report layout and format so that it is used each time that you perform an operation on the PivotTable, select the Preserve cell formatting on update check box.
--To discard the PivotTable report layout and format and resort to the default layout and format each time that you perform an operation on the PivotTable, clear the Preserve cell formatting on update check box.

 

[davidd31415]

Thanks dianemarie but when I click the question mark and then click on 'Preserve' the pop-up help states "this option is not available for the pivot chart." It's the chart lines that I would like to format. After reading that pop-up tip I'm thinking I'll need to write a bit of VBA code to accomplish this.

 

[SkipVought]

Turn on your macro recorder and have at doing the format.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}