Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pie chart & column chart w/same source data | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Chart Wizard Data Source | Charts and Charting in Excel | |||
get edit mode on data lines in chart wizard | Charts and Charting in Excel | |||
Chart wizard picks wrong data for axis | Charts and Charting in Excel |