alternate series selection method?

[Hammer_757]

I’m changing the Data Series Format of some of the data on a chart wit
many series of data. To do this I select the series and right click
then change the properties as needed.

The problem I’m having is that the chart is heavily populated an
sometimes selecting a point is difficult. Is there a way to “tab
through the series, once I have one of them selected, so that I don’
have to click each one

 

[Jon Peltier]

Hammer -

The up and down arrow keys cycle through the series and the other chart
elements. You can also select a series using the Chart Element dropdown
on the Chart command bar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Hammer_757]

thanks Jon, sometimes the obvious isnt obvious enough :