View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You would have to program a macro to do this automatically. Data labels
are difficult enough, and worse in a pie chart; trying to add drawing
objects to a chart is listed in the dictionary under "frustration".

Perhaps you should revisit your choice of chart type. 20 objects is an
awful lot to keep straight in a pie. How about a one-column stacked
column chart (or 100% stacked)? You can either use data labels, if the
individual stacks don't get too small, or you could use the legend,
which should list the entries in the same top-to-bottom order as in the
chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


rav3n wrote:

When I make a pie chart with maybe 20 objects, I have a problem with the
arrows pointing to each object. Every time I make a new chart, I´m forced to
draw EVERY object (with it´s arrow) from the pie so that I can read the name
of all the objects. I´ve heard there is a way to draw them all at once
automaticly.

Any help would be appreciated. Thanks.