Auto Data Source Adding

[Mr. Platypus]

I am developing a series of charts that will have data added to them on a
monthly basis. Specifically, I would like the data source to add one column
of data every month. Currently, all I could come up with was highlighting a
bunch of empty fields and letting the data catch-up. The problem with that
is: it leaves a big blank space in the chart.

Any ideas?

 

[Andy Pope]

Hi,

If the new column is an additional data point to an existing series then
you can use named ranges to create a dynamic chart.

http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy