Cluttered labels on refresh

  • Thread starter Thread starter Chance
  • Start date Start date
C

Chance

I have a pie chart that gets its info from a pivot table.
My problem is every time I refresh the pivot table all of
the labels for the pie slices get s cluttered up and you
can't read them. So I then have to manually go and
separate each label. Is there a way for it automatically
spread them out.

Thanks,
Chance
 
Chance -

Microsoft admits that pivot charts have a problem losing their
formatting when you refresh the pivot tables.

XL2000: Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904

They recommend that you record a macro while fixing your chart, then
rerun the macro whenever you refresh the chart.

- Jon
 
Back
Top