Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make chart axis visible/invisible with VBA
Hello.
I'm using Excel 2003. I have a chart on a page and I want to set the scale on the Y axis programatically with VBA. I have written code that does this successfully. The problem: The code will not work if the Y axis is hidden (which I want) - it throws an error saying it can't set the Maximum value. Where I need help: I'm having trouble writing the code to make the Y axis visible, then invisible again. The idea being that I'll display it, set the scale, then hide it again. I've looked around in the newsground and internet and I haven't been able to find what I'm looking for. Any help is appreciated. Thanks. -- Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a chart axis visible/invisible with VBA | Charts and Charting in Excel | |||
Chart Tiltes and axis are invisible, however they and print, help | Charts and Charting in Excel | |||
Check Box to switch make comments visible or invisible | Excel Discussion (Misc queries) | |||
Fast way to make rows visible and invisible | Excel Programming | |||
How do I make a command button invisible or visible? | Excel Programming |