Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display more than 20 labels in a Pie chart?
I am building a pie chart that is intended to have 22 pie-pieces with
data but somehow when I try to ad labels for more than 20 labels excel will not accept this. Any ideas? /Göran |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display more than 20 labels in a Pie chart?
I'm not sure I would accept it either. 22 pie wedges? 22 labels? 6 point
text, I presume, and it still would be a cluttered mess. I did just try this in Excel 2003. I made a chart with 26 equal wedges and the labels A through Z. Worked as expected. Then I tried in 2007, and that worked too. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I am building a pie chart that is intended to have 22 pie-pieces with data but somehow when I try to ad labels for more than 20 labels excel will not accept this. Any ideas? /Göran |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display more than 20 labels in a Pie chart?
Actually as it turned out it was not the # of sections that was the
issue, it was the numer of characters in the string defining the chart that was the problem. It was larger than the 255 charcters allowed so I needed to do an adjustment in sheet and filed names and then it worked. /Göran Jon Peltier skrev: I'm not sure I would accept it either. 22 pie wedges? 22 labels? 6 point text, I presume, and it still would be a cluttered mess. I did just try this in Excel 2003. I made a chart with 26 equal wedges and the labels A through Z. Worked as expected. Then I tried in 2007, and that worked too. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I am building a pie chart that is intended to have 22 pie-pieces with data but somehow when I try to ad labels for more than 20 labels excel will not accept this. Any ideas? /Göran |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Data Series Labels in Area Chart | Charts and Charting in Excel | |||
display cell value on a pivot chart | Charts and Charting in Excel | |||
hierarchical axis labels reverse chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel |