Results 1 to 2 of 2

Thread: dashboard...

  1. #1

    dashboard...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to build an interactive dashboard based on the value selected in the dropdown box. I have included a sample data file which contains two tabs.
    Data and dashboard, by looking on the dashboard you will see how I want to display the data.

    thanks for your help!
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    See attached: excelguru2306sample data.xlsx
    I'm a bit cross, because after having spent significant time finding a solution for you I discover you've cross posted and have probably got a solution elsewhere; I feel I've wasted my time.
    Some light reading: http://www.excelguru.ca/content.php?184

    Cross posts:
    http://forum.chandoo.org/threads/int...shboard.12877/
    http://www.excelforum.com/excel-gene...filtering.html

    If I'd known, I could have spent the time dealing with your "...I have another scenario that", but I'm out of time now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •