+ Reply to Thread
Results 1 to 7 of 7

Drop down list - changing / interactive chard based on selection

  1. #1
    Registered User
    Join Date
    10-07-2020
    Location
    Nottm, England
    MS-Off Ver
    365
    Posts
    33

    Drop down list - changing / interactive chard based on selection

    Hi all,

    I want to create an interactive chart that changes based on the selection from a drop down list.

    So, I know how to create a drop down list I don't have a problem with that.

    I have a grid of different KPIS on the left going down in the first column and years across the top, with the relevant values going across accordingly:

    15/16 16/17 17/18 18/19 19/20 20/21 YTD
    Volume

    Reviews

    Financial Output

    How do I create this interactive graph linking it up to the drop down list?

    Many thanks,

    EB

  2. #2
    Registered User
    Join Date
    10-07-2020
    Location
    Nottm, England
    MS-Off Ver
    365
    Posts
    33

    Re: Drop down list - changing / interactive chard based on selection

    I have attached the example workbook.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-20-2020
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    6

    Re: Drop down list - changing / interactive chard based on selection

    I have no idea if I understood your problem correctly, but have you considered using a vlookup?

  4. #4
    Registered User
    Join Date
    10-07-2020
    Location
    Nottm, England
    MS-Off Ver
    365
    Posts
    33

    Re: Drop down list - changing / interactive chard based on selection

    extendoffice.com/documents/excel/1440-excel-create-interactive-charts.html

    This is what i'm trying to achieve. Except this method wouldn't be interactive & adaptable as I wouldn't be able to change any figures in the table and it be updated as the graphs are linked to pre linked pictures.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Drop down list - changing / interactive chard based on selection

    The attached copy of the file illustrates one way of producing an interactive chart:
    1. Copy/Paste (Transpose) the years in cells N2:N7
    2. Populate O1 using: =L2
    3. Populate O2:O7 using: =INDEX(Table1[[2015/16]:[2020/21 Q2]],MATCH(L$2,Table1[PIPD001],0),MATCH(N2,Table1[[#Headers],[2015/16]:[2020/21 Q2]],0))
    The graph is then produced from the values in N1:O7, where O2:O7 will change dependent on the selection in cell L2.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Registered User
    Join Date
    10-07-2020
    Location
    Nottm, England
    MS-Off Ver
    365
    Posts
    33

    Re: Drop down list - changing / interactive chard based on selection

    Brilliant, cheers JeteMc

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Drop down list - changing / interactive chard based on selection

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  2. [SOLVED] Changing dates based on drop-down selection?
    By dg7985 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2014, 10:08 PM
  3. Changing Data Based on Drop Down Box Selection
    By vesely.4 in forum Excel General
    Replies: 3
    Last Post: 01-31-2013, 07:48 PM
  4. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  5. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  6. Changing Pivot Report Filter based on Drop Down List Selection
    By rajuasq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 11:40 AM
  7. Changing values based on drop down menu selection
    By henro8 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2010, 03:47 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