I have a bar chart on a report. The number of different bars that have to fit onto the page mean that I want to set the font size for all data labels to 7. I can click on them one at a time and change it, but is there some 'global' setting for the chart as a whole that I can set? If so, where is it?

Thanks in advance.

The only tricks I know of so far are these two.
In design if you click on the label in the toolbox, before you place the label you can change the default settings so all the subsequent labels you place will have that as an initial setting for all the labels.
If you use the wizard to build and go back to edit then CtrlA selects everything and use shift and click to discount anything you do not want to change or the stuff that is not a label.

Thanks for that.

Unfortunately, the chart was created using the wizard and when viewed in design mode only the first thrity or so labels are visible. I've tied changing all of those to a smaller font, but as soon as extra rows are created, the font for those reverts to the larger size.

Something to try: -


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

With Me.NameOfGraph.Axes(1).TickLabels.Font
.Size = 7
.Name = "Arial"
.FontStyle = "Normal" ' "Bold Italic"
.Color = vbRed
End With

End Sub


Hope that helps.

Thanks very much for that. Definitely looks promising.

As is his wont, my manager now has me working on something completely different. I shall get back to the report asap and let you know how I get on.