Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO ADD LEGENDS IN CHART | Excel Discussion (Misc queries) | |||
Dynamic chart legends | Charts and Charting in Excel | |||
Chart Legends | Charts and Charting in Excel | |||
Excel Chart Legends need alignment option (rotate 90-180-270 deg) | Charts and Charting in Excel | |||
Problem with Legends in chart | Excel Programming |