software

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: www.excelforum.com/member.php...oamp;userid=28766
View this thread: www.excelforum.com/showthread...hreadid=540051The 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
PeltierTech.com/
_______

quot;amrezzatquot; gt; wrote in
message ...
gt;
gt; hey guys
gt; i have two charts in a sheet
gt; how to change the font size and AutoScaleFont of datalabels in them
gt; through VBA??
gt;
gt; --
gt; amrezzat