Hi, I have a graph that has 189 series of data. I have a mechanism for selecting which ones to display (use of checkboxes not a pivot table) so that they are not all visible at the same time! However each week I need to add another set of values for each series. Is there an easy way of doing this?
Large number of data series all need range changed each week?
- Thread starter clarky
- Start date
Clarky
Firstly, Welcome to the Chandoo.org Forums
This is a great application for use of Named Formulas or Data Tables
Typically you will setup a named Formula for each series in the Chart
Then named formula will use an Offset, Index or indirect function that allows the range to dynamically expand as data is added.
Orb you can use an Excel Data Table
I'd suggest having a read of: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
Firstly, Welcome to the Chandoo.org Forums
This is a great application for use of Named Formulas or Data Tables
Typically you will setup a named Formula for each series in the Chart
Then named formula will use an Offset, Index or indirect function that allows the range to dynamically expand as data is added.
Orb you can use an Excel Data Table
I'd suggest having a read of: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/