Auto Data Source Adding
 

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?

Auto Data Source Adding
 

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

Mr. Platypus wrote:
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, Microsoft MVP - Excel
http://www.andypope.info