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?