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.