The easiest way to get round this one is to record a macro of you setting up
a new graph and changing the data label font size, then cut and paste it
into your existing Macro/VB.

I know this isn't exactly what you want, sorry.

Ric

"Sean Howard" wrote in message
...
Does any know how to change the default font for DataLabels on an Excel
chart?. When you turn on Datalabels they always seem to be in Arial 12pt
size. This means that I have to programatically change the Font/Size/etc
for every series in the chart to get the desired effect I cannot help
thinking that there must be an easier way but I simply cannot find it.

Sean

P.S. Does anyone have an idea why the ApplyDataLabels method does not
work in Microsoft Graph?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!