Does anyone know if there is a built in keyboard shortcut or sequence of keys that will navigate between the spreadsheet and an embedded chart? It will be easy enough to create a macro, if needed (activesheet.chartobjects(1).select assigned to a reasonable keystroke), but I am first wondering if the keystroke is already built in.
Originally Posted by shg
Ctrl + Page Up or Page Down moves between sheets, not sure if it would work what you are wanting though.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Right, that works very well for charts that are in their own chart sheet. I am hoping for something just like ctrl + Page Up/down that will let me navigate between a worksheet and its embedded chart (or charts).
Select one chart then the Tab key will jump from chart to chart. Shift tab goes in reverse.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Only other way I know if is Ctrl + 6, but that just hides/unhides the chart.
newdoverman, that's almost what I am looking for, except for a key that will also jump back and forth between the spreadsheet and the chart(s).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks