Charting with VBA
 

I've been working in excel 2000 and i'm running into a strang
limitation while attempting to generate charts in VBA

I'm trying to generate a pie chart and i create a temp worksheet an
chart sheet. Then i read the relevant data into some string arrays the
i do


with chrtOutput.seriescollection(1)
.Values = iValues
.XValues = sLabelData
end with

Unfortunately the .Xvalues assignment ends up failing when any elemen
of sLabelData() contains more than 15 characters and contains more tha
one spaces.

All I really want it is for the labels to appear in the legend. Anyon
have any suggestions on how to work around this limitation? I'm reall
fresh out of ideas (most of my mental energy was spent figuring out wh
the .XValues assignment was failing).

I'd prefer if possible a solution that doesn't involve using range
instead of string arrays

--
Message posted from http://www.ExcelForum.com