• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Large number of data series all need range changed each week?

clarky

New Member
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?
 
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/
 
Thanks Hui, i'll go ahead and look at those options.


I've been passively following this site for quite some time and have used many ideas for from Chandoo's charts to liven up my charts among other things. Keep the good work up.
 
Back
Top