dashboard...

cloudno9

New member
Joined
Nov 3, 2013
Messages
1
Reaction score
0
Points
0
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!
 

Attachments

  • sample data.xlsx
    20.6 KB · Views: 67

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,199
Reaction score
16
Points
38
Excel Version(s)
365
See attached: View attachment 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/interactive-dashboard.12877/
http://www.excelforum.com/excel-general/965772-interactive-dashboard-and-data-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.
 
Top