+ Reply to Thread
Results 1 to 5 of 5

Create a Dropdown List linked to different graphs

  1. #1
    Registered User
    Join Date
    04-07-2020
    Location
    Portugal
    MS-Off Ver
    16.35
    Posts
    2

    Exclamation Create a Dropdown List linked to different graphs

    Hi,

    I really need some help with this task.

    So I need to create one dropdown list with a row information (example: Home | Street | Store) etc
    and I have different columns with values for the same header (example: HOME
    meters|centimeters).

    What I need is to create a dropdown list where I find HOME select and shows two graphs with the title HOME but one with Y values in meters and other with Y values in centimeters.

    How can a single option of the combobox or dropdown list can be associated to different graphs with the same X values but different Y values?

    I hope you can understand me and help. Please help!

    Thanks in advance!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Create a Dropdown List linked to different graphs

    Hi and welcome
    are you using Excel on Mac?

  3. #3
    Registered User
    Join Date
    04-07-2020
    Location
    Portugal
    MS-Off Ver
    16.35
    Posts
    2

    Re: Create a Dropdown List linked to different graphs

    Yes, I am.

    Thank you.

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

    Re: Create a Dropdown List linked to different graphs

    Perhaps the following will help.
    1. Produce two pivot tables from the data
    2. Produce a slicer that is connected to both pivot tables
    3. Produce a graph from each pivot table
    Change selections on the slicer to test.
    If this isn't helpful then please utilize the instructions in the banner at the top of the page to upload a sample. Please attempt to manually include the output you would like to see so that we will have a better idea of what our formulas/code should accomplish.
    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.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Create a Dropdown List linked to different graphs

    Administrative note
    In the future please post in the correct sub-forum.
    I moved it for you.
    Thanks

+ 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: 5
    Last Post: 02-25-2020, 02:02 PM
  2. [SOLVED] Create a list with dropdown linked to a reference no.
    By Roma1r in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-04-2018, 11:39 AM
  3. [SOLVED] Create an Excel Drop Down list with Search Suggestions ( Serachable Dropdown list )
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2016, 12:03 AM
  4. Create dropdown list in Excel that will only list unique entries
    By MissAudrey in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2015, 04:56 PM
  5. IF statement linked to variables in a dropdown list
    By H57 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2013, 12:12 PM
  6. [SOLVED] Create different graphs depending on dropdown list
    By Candbapt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2013, 10:00 AM
  7. Dropdown list linked to a formula
    By D_N_L in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2011, 05:46 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