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

Hi,

The pie chart already attempts to arrange the labels when using Best fit.

I suggest you consider another chart type, such as column, that would be
better suited to displaying your labels and making the reading of the chart
easier.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Liztd" wrote in message
...
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