Any idea how to change the text in the legend?

Ono
Ono used Ask the Experts™
on
I have mschart and have the legend displayed, but how can I change the Text for each individual sets of lines in my graph ? the preset values are actually 'C1' and 'C3' and etc. so on....
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
     .Column = 1
      .ColumnLabel = "MyColInfo"
      .Row = 1
      .RowLabel = "MyRowInfo"

      .Column = 2
      .ColumnLabel = "YourLabel"
      .Row = 2
      .RowLabel = "MyRowInfo"
Ono

Author

Commented:
erm, thanks twalgrave again, yeah, I know about that command but then it's not actually those that I wanted to change.
See this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconmanipulatingchartappearance.asp

those 1st pic. and those text in the legend box, are text that I wanted to change.

Ono.
Those are the changes that I get when I use this code.  I tested this on my machine.  The legend changed and so did the text on the lines.  I don't know what to tell you.
Ono

Author

Commented:
Opz, Sorry twalgrave,

I've forgot to mention that I'm using "chartType = VtChChartType2dXY" for the mschart. I've tried the commands as you have commented, but it wouldn't work.
Ono

Author

Commented:
Ops, twalgrave, you're right. What happened was that I named the .column stuff before adding the array into the chartdata, hence, I'm suppose to add in the array into the .chartdata before naming the .columnlabel

Thanks again,
Ono

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial