I have an Excel sheet that contains both a pie chart and line chart. Both of these charts need to dynamically update based on a user setting. The difficulty here is that the user setting can actually change how many rows of data there are for the chart (either 1 or 4). I used the following page to figure out how to dynamically update the pie chart -http://chandoo.org/wp/2009/10/15/dyn...t-data-series/. However, updating the line chart is more difficult. In this case, updating the setting can actually change how many series of data there are (in this case, each row is a series as each data point represents a month). As I know this a bit confusing, I will give an example below.
User Setting 1 - Pie Chart
A 50
User Setting 2 - Pie Chart
A 50
B 30
C 10
D 10
User Setting 1 - Line Chart
A 100.5 75 45
User Setting 2 - Line Chart
A 34 56 45
B 34 231 345
C 32 23 123
D 123 34 123
What I cannot figure out is how to dynamically include only the first row in the line chart when user setting 2 is selected. If this is still unclear, please let me know and I will try and explain it differently.
User Setting 1 - Pie Chart
A 50
User Setting 2 - Pie Chart
A 50
B 30
C 10
D 10
User Setting 1 - Line Chart
A 100.5 75 45
User Setting 2 - Line Chart
A 34 56 45
B 34 231 345
C 32 23 123
D 123 34 123
What I cannot figure out is how to dynamically include only the first row in the line chart when user setting 2 is selected. If this is still unclear, please let me know and I will try and explain it differently.