+ Reply to Thread
Results 1 to 6 of 6

Keyboard shortcut to select embedded chart

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,366

    Keyboard shortcut to select embedded chart

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Keyboard shortcut to select embedded chart

    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

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,366

    Re: Keyboard shortcut to select embedded chart

    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).

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Keyboard shortcut to select embedded chart

    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

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Keyboard shortcut to select embedded chart

    Only other way I know if is Ctrl + 6, but that just hides/unhides the chart.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,366

    Re: Keyboard shortcut to select embedded 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).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Keyboard shortcut to select column by the column letter
    By Megatronixs in forum Excel General
    Replies: 10
    Last Post: 07-24-2014, 04:29 AM
  2. Replies: 3
    Last Post: 02-21-2014, 10:19 AM
  3. [SOLVED] Keyboard Shortcut
    By HangMan in forum Excel General
    Replies: 2
    Last Post: 05-22-2013, 04:17 PM
  4. Name Box Keyboard Shortcut
    By Maxx57 in forum Excel General
    Replies: 3
    Last Post: 02-17-2010, 07:20 PM
  5. Replies: 2
    Last Post: 04-16-2009, 04:11 PM
  6. SELECT EMBEDDED EXCEL CHART
    By lesy99 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2006, 07:10 PM
  7. [SOLVED] keyboard shortcut
    By Dave in forum Excel General
    Replies: 3
    Last Post: 02-15-2006, 08:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1