I need to make a macro that when run extends the source data for a chart by one cell. In words: when macro is run chart's new source data = old source data + one cell.

Any ideas?