+ Reply to Thread
Results 1 to 5 of 5

Switching between charts

  1. #1
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Switching between charts

    Is there a way to create a drop down to switch between charts (what about pivot charts)? I found this link, but it only works if you can put the entire graph in one cell..
    http://chandoo.org/wp/2008/11/05/sel...art-from-many/

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Switching between charts

    I would start by asking what you want differently than how the above method works?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Switching between charts

    I have three pivot charts, but they take up a lot of real estate, so I'd like to create a drop down box (or anything really) that will allow me to switch between them. The above link won't help me.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Switching between charts

    I suppose you could use VBA to bring over whatever you want instead.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Switching between charts

    You can modify the hack to use named ranges that cover more than a single cell.

    All you need are named ranges for each chart, formula to return named range (associated with dropdown) and linked picture.
    Cheers
    Andy
    www.andypope.info

+ 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. Switching the x and y axis
    By agentsch in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2014, 12:22 PM
  2. Considering switching to a Mac
    By GlenSydney in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 05-09-2014, 09:03 AM
  3. Switching Ink On or Off
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2010, 05:16 PM
  4. switching last name/first name
    By charlie11k in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2009, 11:13 AM
  5. Excel charts should allow "switching" series on or off
    By Robert in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-18-2006, 03:55 AM

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