Navigating through chart Source Data wizard
 

I have a number of charts that have 12-20 series each which need to be
changed to different X and Y values. In the Source Data wizard I can
click on the name of a series and then tab through the different
fields and manually type in the changes.

Then I have to go back to the mouse to click on the name of the next
series so I can tab through its fields. I'm wondering if there is a
keystroke that will move on to the next series name. I've tried a
couple of combinations that seemed likely but no luck. Any ideas?
Thanks!

Navigating through chart Source Data wizard
 

Keep tabbing, eventually the selected series in the series listbox will
receive focus. At that point you can navigate the series using the up and
down arrow keys. In 2003, the sequence of tabs is

Series List
Name
X Values
Y Values
Add
Remove
OK
Cancel
Series Tab
Series List
....

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


wrote in message
...
I have a number of charts that have 12-20 series each which need to be
changed to different X and Y values. In the Source Data wizard I can
click on the name of a series and then tab through the different
fields and manually type in the changes.

Then I have to go back to the mouse to click on the name of the next
series so I can tab through its fields. I'm wondering if there is a
keystroke that will move on to the next series name. I've tried a
couple of combinations that seemed likely but no luck. Any ideas?
Thanks!