I have a list box that is showing locations and a Pie Chart that is showing percentage of SF per Location
Now the chart is showing correctly the Percentage of SF by Locations. Like I have 20 Locations and each one has its slice on the chart and the right Percentage.
How can I do the follwing:
If I select a location from the list box, the Pie chart shows the percentage of selected location Vs All others(In other words: One color for this location "Slice" and a second color summing all other locations"Slices").
This is helpfull but the logic that i have is a little confussing.
I think that i am going to do it differently.
I am going to build to charts the first one will show me the selections as I explained how they are showing up now and the second will show the percentage as i needed as there is no way of showing both at the same time.
Do you know how to hide and show a chart if a selection in made in a list box?