Click to See Complete Forum and Search --> : MSChart


RSH
October 9th, 2001, 07:01 PM
Any of you guru's know how to label the legend that is generated by MSChart. I have 12 bars of varying colors which are called C1 thru C12. I need to give them month names.
73 RSH

Cimperiali
October 10th, 2001, 02:20 AM
' A small example
private Sub Form_Load()
'change legend description
MSChart1.ColumnLabel = "AAA"
MSChart1.Column = 2
MSChart1.ColumnLabel = "bbb"
MSChart1.Column = 3
MSChart1.ColumnLabel = "CCC"
MSChart1.Legend.Location.Visible = true
'change X description
MSChart1.RowLabel = "aa"
MSChart1.Row = 2
MSChart1.RowLabel = "bb"
MSChart1.Row = 3
MSChart1.RowLabel = "cc"
End Sub




Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

RSH
October 10th, 2001, 08:31 AM
Cimperiali:
That is exactly what I Needed. With a few modifications it works perfectly. This was not to be found in any of the texts that I own.
73 & Thanks
RSH

Cimperiali
October 11th, 2001, 02:55 AM
;-)
Have a nice day


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater