how to change the axis label range of chart in excel vba

Hello

How can we change the Axis Label Range of a chart in excel vba ? or it is something that is unchangeable and determined by Excel itself?


Best Regards
Imran Bhatti

Hi,

You set the XValues property of a series on that axis to whatever range you want.

Thanks xlnitwit
I want to set the Range("A7:A54") as an Axis Label Range at run time,what would be the method.In other words
I need to switch the Axis label range from one that is already in the chart (manually) to another Range("A7:A54") at run time.
My chartsheet name is =Chart14
Sheet Name=Sheets("DataValue") ' in which the actual data resides

You would require something like

Please Login or Register  to view this content.

will inform you after testing. Thanks for taking the time,