Can I create a chart from a data source that grows each month, automatically?

Ideally without having to go into the chart each month and modify the data source's?

A data source might look like this:

Please Login or Register  to view this content.

But each month another column is added. Can the end of the data source be so automated? I don't want a chart with blank entries for the not-yet-filled-in months.

<Thinks...> In fact, I need the addition of the new months data to sheet to be automated as well! Well, why not?

Thanks.

Originally Posted by arthurbr

This link might get you started

Hi Arthur.

I have only glimpsed at the link so far, but it looks like you've landed dead on target. Thanks very much. I'm going to pre-empt success and mark this as solved already!

Mike.