Does my secondary axis exist?

[ajwillshire]

Hi,

I've got a routine which builds up a chart using VBA using values created in a table. In the table the user has the option of plotting a series on the primary or secondary axis and it will be assigned there using the .Axisgroup property.

So far so good.

However, I want to add titles to the axes which is easy for the category axis and the primary value axis. The problem is checking if the secondary axis has been created or not. If it hasn't been created and my code tries to edit it then I get an error.

I guess I could resolve this with just an "On error, resume next" but ideally I'd like a line of code which will tell me if the axis exists so that I can exclude the formatting using an If statement.

Can anyone help?

Many thanks in advance,

Andrew

 

[pcc]

If the user has an option to plot on a primary or secondary axis then there must be a user input eg option button/checkboxes. Set up a boolean operator based on the user's selection, then use this as a condition for formatting the secondary axis or not as appropriate

 

[ajwillshire]

Thanks. I can easily check the row in the table to see if the user has entered "2" anywhere - perhaps I'm trying to be too clever.

Just for my own learning though, is there any way to test if the axis exists (or other similar objects)?

 

[RoryA]

Not really. You can test the Axes.Count but it is possible to have only 2 Y axes for example, so it's not definitive. I use an error handler.

 

[ajwillshire]

Cool, thanks. Error handler it is.