I am working on creating an interactive dashboard that filters data through a drop down list on the dashboard then displays it alongside the Scatter plot chart.
Basically the user would select the Clinic and/or the Provider which would then display the filtered list and scatter plot connected to it.
I am using Excel 2010 so pivot tables dont work well with scatter plots. I have attached a sample sheet of what i had in mind.
Any direction would be great.
thanks
Basically the user would select the Clinic and/or the Provider which would then display the filtered list and scatter plot connected to it.
I am using Excel 2010 so pivot tables dont work well with scatter plots. I have attached a sample sheet of what i had in mind.
Any direction would be great.
thanks