bar graph LABEL font size

[Audiology]

Is there an Excel-intrinsic or third party batch process alternative to changing bar graph LABEL font size bar-by-bar?

audiology

 

[Andrew Poulsom]

Do you mean Data Labels? You should be able to right click one, choose Format Data Labels and change the font size of all of them.

 

[Audiology]

Andrew,

I can change one label font size at a time. Is there a way to batch-change ALL the label sizes?

audiology

 

[Andrew Poulsom]

You can change all of them at once for a given series.

 

[RoryA]

What Andrew said does exactly that unless:
1. All your bars are separate series; or
2. You have already selected one specific datalabel (in which case, select something else in the chart, then right-click a data label)

 

[Audiology]

Rorya, Andrew

Thank you. The functional demands of the display require each bar as a series.

audiology

 

[RoryA]

you would need code then, if that's an option?