Hello
I've got a reasonable amount of experience with excel but I'm a bit lost in this situation. We are trying to create a dashboard that is displaying information for different locations. The goal is to provide a combo drop down box that lists each location. When you select a location all information in all charts is updated to reflect the data for the chosen location.
Currently we have 7 charts that pull data from 7 different tables. Each location's data has been configured in exactly the same way so the formulas all should shift to the tables associated with that particular location.
I'm not sure how to go about this.. I currently have one location charted correctly, and I have a dropdown that allows me to display and select the options however I am not sure how to associate each drop down with their respective tables and then display those tables in the correct corresponding chart.
I've got a reasonable amount of experience with excel but I'm a bit lost in this situation. We are trying to create a dashboard that is displaying information for different locations. The goal is to provide a combo drop down box that lists each location. When you select a location all information in all charts is updated to reflect the data for the chosen location.
Currently we have 7 charts that pull data from 7 different tables. Each location's data has been configured in exactly the same way so the formulas all should shift to the tables associated with that particular location.
I'm not sure how to go about this.. I currently have one location charted correctly, and I have a dropdown that allows me to display and select the options however I am not sure how to associate each drop down with their respective tables and then display those tables in the correct corresponding chart.
