Pie Chart Labels Overlapping

greare · May 15th, 2002, 09:29 AM

Hi
I am working with a pie chart in which the labels overlap because the % of the pie are close together.

Is there an automatic way, a macro, or anything that will make adjustments and maybe even draw the lines out from the pie pieces to the label?

Just curious if I was going to have to do it manually or not.

Thanks.

Mark W. · May 15th, 2002, 11:15 AM

Seems to me that this is more of a question about aesthetics. Not quite sure how you'd define an all-encompassing set of guidelines that could be "automated". You can manually position your labels and have "leader lines" (see the checkbox on the Chart Options' Data Labels tab).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 09:29 AM	#1
greare New Member Join Date: Feb 2002 Posts: 1	Hi I am working with a pie chart in which the labels overlap because the % of the pie are close together. Is there an automatic way, a macro, or anything that will make adjustments and maybe even draw the lines out from the pie pieces to the label? Just curious if I was going to have to do it manually or not. Thanks.

May 15th, 2002, 11:15 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Seems to me that this is more of a question about aesthetics. Not quite sure how you'd define an all-encompassing set of guidelines that could be "automated". You can manually position your labels and have "leader lines" (see the checkbox on the Chart Options' Data Labels tab).