Selecting chart elements without having to double-click on them

Hi there,
I have created a chart with a secondary y-axis. I have unchecked the
y-axis's tickboxes and so on so that it is effectively hidden. The
problem is when I want to select it again in order to change the scale
setting (for example) I can't find it. So even if I hover in that area
with my mouse, Excel does not identify it, making it impossible to
double-click to format the axis. I find this happens when to chart
becomes complex/busy, making it difficult to select elements with the
mouse. So my question is this - is there another way to select chart
elements, in stead of using the mouse?

Chart toolbar?
<roosthuizen@nedsec.co.za> wrote in message
news:1139911164.995743.99520@g44g2000cwa.googlegroups.com...
> Hi there,
> I have created a chart with a secondary y-axis. I have unchecked the
> y-axis's tickboxes and so on so that it is effectively hidden. The
> problem is when I want to select it again in order to change the scale
> setting (for example) I can't find it. So even if I hover in that area
> with my mouse, Excel does not identify it, making it impossible to
> double-click to format the axis. I find this happens when to chart
> becomes complex/busy, making it difficult to select elements with the
> mouse. So my question is this - is there another way to select chart
> elements, in stead of using the mouse?
>

roosthuizen -

Up-Down arrow keys cycle through the major chart objects.

Left-Right arrow keys cycle through all chart objects.

- Mike
www.mikemiddleton.com

<roosthuizen@nedsec.co.za> wrote in message
news:1139911164.995743.99520@g44g2000cwa.googlegroups.com...
> Hi there,
> I have created a chart with a secondary y-axis. I have unchecked the
> y-axis's tickboxes and so on so that it is effectively hidden. The
> problem is when I want to select it again in order to change the scale
> setting (for example) I can't find it. So even if I hover in that area
> with my mouse, Excel does not identify it, making it impossible to
> double-click to format the axis. I find this happens when to chart
> becomes complex/busy, making it difficult to select elements with the
> mouse. So my question is this - is there another way to select chart
> elements, in stead of using the mouse?
>