+ Reply to Thread
Results 1 to 3 of 3

Auto chart adjustments based on dropdowns

  1. 11-19-2021, 04:36 PM #1
    Brunheas
    Brunheas is offline
    Registered User
    Join Date
    04-28-2021
    Location
    United States
    MS-Off Ver
    2019
    Posts
    2

    Auto chart adjustments based on dropdowns

    I have multiple projects each with multiple parameters.

    Screenshot 2021-11-19 152615.jpg

    My goal is to have an auto adjusting chart based on 4 different projects and parameter that I select in dropdowns.

    Screenshot 2021-11-19 153404.jpg

    I am not sure how to connect the chart with the drop downs to make it dynamic. Any help is appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-20-2021, 05:22 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,429

    Re: Auto chart adjustments based on dropdowns

    One way,

    add formula to get the positional index of Projects and Parameter. The build a data set for the chart using INDEX
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 11-23-2021, 04:42 AM #3
    Pichai_Tee
    Pichai_Tee is offline
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    17

    Re: Auto chart adjustments based on dropdowns

    Inset Table, then Insert Slicer.
    Default Chart will show only display data (not filtered).
    Visit my YouTube channel Excel NaNa
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multi dependent dropdowns with auto-generated cell
    By AlPragOrg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2021, 11:24 AM
  2. Dependent Dropdowns & Auto Filling Cells based on table
    By Mic_ExcelNoob in forum Excel General
    Replies: 9
    Last Post: 08-03-2020, 04:01 AM
  3. [SOLVED] VBA for dropdowns based on another dropdowns
    By abhi_jain80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2016, 05:14 AM
  4. Formulate to auto fill cells after selecting dropdowns
    By Kesar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 01:24 PM
  5. [SOLVED] Chart needs to auto populate items from master referance chart based on job description.
    By gluktar in forum Excel General
    Replies: 5
    Last Post: 12-05-2012, 12:07 PM
  6. Chart using Multiple Data Sets and Dropdowns...
    By HARDING22 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2012, 02:44 PM
  7. Chart using Multiple Data Sets and Dropdowns...
    By HARDING22 in forum Excel General
    Replies: 0
    Last Post: 04-02-2012, 06:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1