Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a large number of charts whose underlying data is updated weekly. A typical series looks like this:

Summary!B2:B7

Each week I add another row of data and update the series accordingly:

Summary!B2:B8

The problem is that I have to manually update the series in dozens of charts each week. How can I have my charts dynamically update their series values, perhaps by referencing a single cell or cells that I can change in one place?

share|improve this question
1  
I ran out of time to give you an exact answer, if when I get back I see you don't have one, I'll pin it down for you. The general answer is that you use named ranges so that you can always change your range. –  Lance Roberts Nov 7 '10 at 0:41
add comment

1 Answer

up vote 1 down vote accepted

In most cases you can have the series pointing to a larger range of cells than you have data for. Cells with no data are simply ignored and not included on your chart.

So in your case, you could define the series as Summary!B2:B100 and gradually add data as it becomes available.

share|improve this answer
    
That worked! Thanks for such a simple solution. –  Mike Sickler Nov 8 '10 at 4:09
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.