| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| more than 2 secondary y axis with individual ranges of value | Charts and Charting in Excel | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| Secondary X Axis - using named ranges | Excel Programming | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
![Intellihome[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
