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 wrote:

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!