Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Arrows in pie chart
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
Why are Excel 2003 chart arrows and lines invisible with little c. | Charts and Charting in Excel |