change font size for data labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ken - 13 Feb 2006 14:50 GMT

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

Reply to this Message

Br@dley - 15 Feb 2006 01:39 GMT

> Hi,
> How do you change the font for the data labels on your bar graph
[quoted text clipped - 6 lines]
>
> 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).Font.Size = ?
Next

Hope that points you inthe right direction.

Signature

regards,

Br@dley

Reply to this Message