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

Secondary X Axis - using named ranges
 

I found it, it seems like array CategoryNames has it.

But I still have the update problem. Excel would not update workshee
from time to time.

Any ideas appreciated.

Iva

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

Secondary X Axis - using named ranges
 

I found it, it seems like array CategoryNames has it.

But I still have the update problem. Excel would not update workshee
from time to time.

Any ideas appreciated.

Iva

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

Secondary X Axis - using named ranges
 

Sorry....

It works now, focus problem again.

To make Application.Calculate work all the time, focus needs to be se
on the sheet that you work with.

Sorry again for posting this, rather stupid, question. I am stil
learning Excel.

Iva

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

Secondary X Axis - using named ranges
 

Sorry....

It works now, focus problem again.

To make Application.Calculate work all the time, focus needs to be se
on the sheet that you work with.

Sorry again for posting this, rather stupid, question. I am stil
learning Excel.

Iva

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