Excel chart - edit Axis Label Range

G

garyj68

New Member
Joined
Mar 8, 2021
Messages
9
Office Version
  1. 2016
Platform
  1. Windows
Hi,

I have a chart and using the Select Data Source option, I have linked the values in the 'Horizontal(Category) Axis Labels' section to cells on a worksheet. This works great.

My question is how to change these labels using VBA.

Thanks

1633612891498.png
 

Attachments

  • 1633612658493.png
    1633612658493.png
    20.8 KB · Views: 6

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Have you tried recording a macro of yourself doing it manually, then modifying the resulting code to suit your exact requirements?
 
Upvote 0
You must log in or register to reply here.

Similar threads

sparky2205
  • Question
X axis doesn't expand to new data range
Replies
0
Views
169
sparky2205
sparky2205
S
  • Question
Excel Pie chart - Specifying colour of label based on value
Replies
0
Views
81
scotthannaford1973
S
O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
337
OrangeJuice
O
A
  • Question
Help Debugging Custom Data Label Macro
Replies
0
Views
136
arndtea
A
R
  • Question
Adding Multiple Vertical Lines on Horizontal Bar Chart
Replies
1
Views
202
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,215,046
Messages
6,122,855
Members
449,096
Latest member
Erald

Share this page

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
Back
Top