change font size for data labels

[ken]

Hi,
How do you change the font for the data labels on your bar graph
report/chart? I have 24 series, and when I change the font of the data
label for one series that does not change them all...
Also in design view I only have 3 series displayed...so I need a way to
change all of them at once...

If anyone knows how to do this I would really appreciate a hint.

Thanks

[Br]

ken wrote:

Hi,
How do you change the font for the data labels on your bar graph
report/chart? I have 24 series, and when I change the font of the data
label for one series that does not change them all...
Also in design view I only have 3 series displayed...so I need a way
to change all of them at once...

If anyone knows how to do this I would really appreciate a hint.

Thanks

You need to reference the chart object
Note, that you will likely need to loop through each axis and then data
point.

I've done something similar to change the point colours...

This is off the top of my head so it likely won't work... reference the MS
Graph object in the module window so you can browse the object model and see
the help on it (not installed by default thought, it's on your Office CD).

For i = 1 to
Me![MyGraph].Object.Application.Chart.Axis(1).DataLabels.Count -1
Me![MyGraph].Object.Application.Chart.Axis(1).DataLabel(i).Fon t.Size = ?
Next

Hope that points you inthe right direction.
--
regards,

Br@dley