Pivot Chart format problems

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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.
 
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
 
Back
Top