View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Liztd Liztd is offline
external usenet poster
 
Posts: 2
Default Auto Arrange Chart Labels

Is it possible for Excel to automatically arrange the labels / series for a
chart so they do not overlap?

I create a pie chart from a timesheet report which contains many data labels.
When the chart is created much of the text is overlaid on top of each other.
I have to manually drag it to different positions around the outside of the
chart in order to be able to view the different catgeories (e.g. Project 1,
Project 2, Holiday, etc).

Is it possible for Excel to realise that the text will not be viewable and
to automatically arrange the data labels so there is no overlap?

Thanks

Liz