hey guys
i have two charts in a sheet
how to change the font size and AutoScaleFont of datalabels in them
through VBA??


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=540051

The required syntax is discoverable using the macro recorder. The final
result would look something like this:

For Each chtob In ActiveSheet.ChartObjects
For Each srs In chtob.Chart.SeriesCollection
If srs.HasDataLabels Then
srs.DataLabels.Font.Size = 8
srs.DataLabels.AutoScaleFont = False
End If
Next
Next

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"amrezzat" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> hey guys
> i have two charts in a sheet
> how to change the font size and AutoScaleFont of datalabels in them
> through VBA??
>
> --
> amrezzat