Secondary X Axis - using named ranges
 

Hello everyone,

I have a chart that has a secondary X Axis.

For all the series' collections for this chart I am using named ranges
however it is not possible in XL97 to use named ranges for a Secondary
Axis.
I need to change lables on that axis depending on a user reaction.
I was trying to change it from a VB code but could not find a metho
that does it.
Could you please tell me if it is different in other XL versions, an
also if it is not how I can do that from VB.

Thank you al

--
Intellihom
-----------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=147
View this thread: http://www.msusenet.com/t-187044688