Make chart axis visible/invisible with VBA

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a chart axis visible/invisible with VBA 2
create chart with column axis 10
Chart SeriesCollection Names 2
Adjusting Y axis scale of a chart using a scrollbar? 9
X-axis labels in charts 1
X-Axis labels 1
different value for setting with breakpoint vs regular running code 3
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ?? 1

Top