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?

 

[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

 

[Jon Peltier]

Sean -

In Tools > Options > General, you can select the default font. This is
applied to cells, and to most text elements of a chart: data labels,
axis tick marks, legend entries. The axis titles are the same, with Bold
added, and the chart title is somewhat larger, in bold.

If you change this to change the data label font, everything else also
will change.

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

 

[Sean Howard]

Thanks Jon,

That works, but unfortunately you have to re-start Excel, which from a
programming view is a bit a of a pain to say the least. Along the same
lines do you know how to achieve the same thing (like the standard font
in Excel) in Microsoft Graph?

Sean

 

[Jon Peltier]

Sean -

I hope you're not changing the user's default settings. That'd tick me
right off!

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

 

[Sean Howard]

Perish the thought Jon. It just seems a strange thing to have to
manipulate OUTSIDE the chart object (who knows how to do the equivalent
in MS Graph).

I think Uncle Bill has let be down again

Sean