Hi,

I try to set the font values of a chart legend. On my computer it works
fine - on a second it does not do anything, without any error messages.
My code:


For i = 1 To [...].DataLabels.Count

Worksheets(1).ChartObjects(1).Chart.SeriesCollecti on(1).DataLabels(i) _
.Font.Size = 50

Worksheets(1).ChartObjects(1).Chart.SeriesCollecti on(1).DataLabels(i) _
.Font.ColorIndex = 33

Next


Does anybody see the problem with this code? In general, would it be
better to reference the chart with the ActiveChart object? Are there
problems with ActiveChart?



Regards, Thomas