Chart Labels

E

Erin

I apologize for double-posting, but I didn't know the best
place to ask this...

I have a series of pie charts that are updated via a
macro. When the data is changed, the labels on these
charts move around (and we know how Excel default labels
line up). I need a way to fix them so they are readable.
Is there any way to do that automatically?

Office 2K, Windows 2K

Thanks

Erin
..
 
K

K Dales

Wish I knew - I have the same frustration. I have found
no "automatic" way to do this.

In theory it should be possible to write a VBA routine
that sets the position of the data labels, but I have not
yet figured out the logic to determine how to position
them. If I ever get a useful routine built I will try to
remember to let you know (at least post it here).
 
Top