Hello,
I am trying to set up a dashboard that is driven by dropdown lists. The attached spreadsheet shows the set up that I want to use. I would like the data to be driven by cell C3 on the "dashboard" tab. I would like the drop down list to follow the hierarchy listed in the text box on "Sheet1" - cells A1 - B6. Basically,the flow of the data should be Area, Region, Territory. Is there anyway to do this? I would also like to hide the zeros on the charts.
Thanks in advanced for the help!
Bookmarks