+ Reply to Thread
Results 1 to 1 of 1

Dynamic excel dashboards with drop down select criteria menu

  1. #1
    Registered User
    Join Date
    07-25-2021
    Location
    Geneva, Switzerland
    MS-Off Ver
    Office 365
    Posts
    1

    Dynamic excel dashboards with drop down select criteria menu

    Hello,
    I would like my dashboard to be dynamic, i.e, have a drop-down menu for the region or income level and if I select region, I want the charts for countries in that region or if I select income level, I want the charts for those countries in that income level categories. these criteria data are other tabs, i.e country code, and regions tabs. The data in the dashboard is coming from the scoring tab, excel the line chart data that will come from a different tab (not in this file). How can I do this and is there a particular way I need to arrange the scoring data for this to be possible?
    Thanks!
    Attached Files Attached Files

+ 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. VBA to select drop down menu
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2019, 02:01 AM
  2. Dynamic Drop Down Menu Ignoring Blank Cells (Dynamic)
    By RaveStarStyle in forum Excel General
    Replies: 12
    Last Post: 10-23-2018, 01:03 PM
  3. Select from a drop down menu using VBA
    By Johnnyv015 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2014, 02:55 PM
  4. Replies: 5
    Last Post: 04-11-2014, 03:13 PM
  5. Excel dynamic dashboards
    By PRodgers in forum Excel General
    Replies: 4
    Last Post: 12-24-2009, 05:27 PM
  6. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 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