Setting font size for datalabels in Excel


2005-04-05 07:38:08 PM
delphi176
Hello,
I try to set the font size for the datalabels of an Excel chart, but I
run into a problem. The code in the Excel macro says :
ActiveChart.SeriesCollection(1).DataLabels.Select
Select.AutoScaleFont = True
With Selection.Font
.Size = 8
....
....
End With
When I try to convert this to Delphi I get stuck, series does have
datalabels property (with an index), but datalabels does not have the
font property.
What I try to do is :
(Chart.SeriesCollection(1,lcid) as Series).DataLabels(1).font.size :=
8;
I use Delphi 2005 in combination with Excel 2002.
Any help is welcom !
Thanks,
Joop