Cluttered labels on refresh

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto positioning of labels outside pie slices 2
Do not display Value label if value = zero 1
How can I reset the default pie chart label "Other" to "Equity"? 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Dealing with a Pivot Table (when I don't want to) 0
Extra pie chart labels in Excel 2007 0
Issues when pivot charts are refreshed and pivots has filters 1
pivot table missing rows? 0

Top