Leader lines

**hermithead** · 12-01-2009, 03:26 AM

I have about 50 charts that when I update the leader lines go all screwey and sometime off the chart which means I spend a great deal of time correcting them.
I tried removing them and just leaving the category label and percentages but even the label text sometimes overlap each other.

Has anyone encounterd this and can recommend a solution, macro, anything?

**teylyn** · 12-01-2009, 03:34 AM

Leader lines? Do you mean trend lines? Care to upload a sample, so we can have a look?

cheers

**Andy Pope** · 12-01-2009, 04:57 AM

Leader lines suggest pie chart.

Leader lines and overlapping labels suggest pie charts with many and or thin slices.

Simplest solution would be to change your chart style.

But as teylyn suggests post an example so we can see the problem.