Dynamically updating a line chart with multiple series

zgall1

New Member
Joined
Jul 6, 2012
Messages
21
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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,127,554
Messages
5,625,474
Members
416,109
Latest member
TripleA00123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top