Legend Value

[DreamKid]

Im trying to put values in the a chart legend in excel.
I refer to a few websites & found out the method below but it seems like "Value" is not a member of LegendEntries. MSDN only provide samples of chrt.Legend.LegendEntries(i).Font.blah... which clearly are not helpful at all.

For i = 1 To chrt.Legend.LegendEntries.Count()
                chrt.Legend.LegendEntries(i).Value = xws.Range("B" & i + 3).Value
            Next

Please advise.
Thank you.

 

[herilane]

The legend entries are based on the series names. As far as I know, you cannot edit the legend entries directly; youll have to change the series names instead.