Excel Chart Datalabels

[Sean Howard]

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!

 

[ric]

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]

dear ric,
I don't think that one is a go missus. I already know how to set the
datalabel font in vb. My question is HOW does Excel decide what the
initial font/size for datalabels is, and can I change this initial value
to something else

Sean


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