View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DevArrah[_2_] DevArrah[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?