Pivot Chart format problems

[Jeff]

Has anyone found a work around besides using a macro to
keep the format of a pivot chart when a value is changed
or when the data is refreshed? Thanks in advance.

 

[Jon Peltier]

Jeff -

You could probably create a custom chart type based on your favorite
chart, then reapply it when the pivot chart is updated.

You could also create a regular chart based on the pivot table, but you
couldn't rearrange the fields from within the chart.

- Jon