![]() |
Legends in a pie chart in excel 2000
I keep running into a problem and i could use some help with either a
creative solution or new way to address the problem I'm trying to create a pie chart (3dexploded) and it appears as though there's some sort of limitation about the amount of text I can use in the legend. I'm using arrays instead of ranges for data points and labels. It ends up choking when do with chrtCreate.SeriesCollection(1) .Xvalues = vLabels end with There's about 17 points (pie slices if you will) and the xValues assignment chokes (as best I can tell) when there is one label that is greater than 15 characters and contains more than one space. Now cutting down the length of the labels is absolutely nonnegoitable. Is there some other way of assigning labels for the pie chart or anyone have any suggestions on how to make this work? |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com