+ Reply to Thread
Results 1 to 4 of 4

Display chart as per drop=down

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    799

    Display chart as per drop=down

    Hi

    Please can someone point me to a solution whereby the chart displayed is as per user selection from a drop-down? I have attached a sample file.

    Is 'camera' the best solution?

    Thanks for all guidance
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,678

    Re: Display chart as per drop=down

    This is a tricky one. To do this I had to change some formatting to put each chart in one big cell. Then I set up a named formula called ShowChart. Then I created an image on the display sheet, and associated with the formula =ShowChart. It uses the value in C7 to determine which cell to show, which brings the chart along with it.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    799

    Re: Display chart as per drop=down

    Mate

    I don't know if there is an award for 'above and beyond', but if there is, there's one waiting with your name on it.

    Thanks and rep added. Star!

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,678

    Re: Display chart as per drop=down

    You are welcome! I had to dig a little to figure this one out but it was fun and I learned something.

+ 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. Replies: 3
    Last Post: 10-01-2019, 01:21 AM
  2. drop down to dispolay no of bars to display in chart
    By Avinashch in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-22-2015, 11:34 AM
  3. Replies: 0
    Last Post: 09-29-2014, 10:32 AM
  4. How to use conditions from 2 drop down lists to display a 3rd drop down
    By arkan01d in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2013, 12:55 PM
  5. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  6. Replies: 2
    Last Post: 06-19-2012, 07:48 AM
  7. [SOLVED] Can I display an Excel chart as my screensaver display?
    By Burke in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-01-2006, 02:05 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