bar graph LABEL font size

Audiology

Board Regular
Joined
Mar 4, 2009
Messages
171
Is there an Excel-intrinsic or third party batch process alternative to changing bar graph LABEL font size bar-by-bar?

audiology
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Board Regular
Joined
Mar 4, 2009
Messages
171
Andrew,

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

audiology
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,812
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

Board Regular
Joined
Mar 4, 2009
Messages
171
Rorya, Andrew

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

audiology
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,812
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
you would need code then, if that's an option?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,422
Messages
5,837,142
Members
430,477
Latest member
roseinsydney

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top