Extend a Graph Source Data Area 1 Column

I have a macro that adds a column on the right side of a table of data every time I use it. I also have a graph that then plots this data. I am looking for a way to create a macro that will incorporate this added column when it is added to the table of data. for instance if I had a 5 row, 10 column matrix, my current macro would make that a 5 row, 11 column matrix and then I would have to manually go to the source data and extend it from being 5X10 to 5X11 to plot the entire set of data.

Thanks in advance for the help.

Does adding a column add a category or series to the chart?

If your matrix is a Table object then it should update automatically.

No it it just gives an update for the day. Kinda like a record of stocks at the end of every day.

that does not really answer the question. I'm trying to understand whether the new column creates new series or extends existing ones.

Is there any reason why you can not use a Table?

It extends existing ones. And I am not entirely sure how to use tables. Thanks for the help.

example of chart linked to table. just enter new data to right of table

Thanks that helps a lot. Though my dates (headers for each column) don't show up properly in the graph.

I can not see what you have so can't say whether there is a work around