Hi Guys,

I have Column A full of date data.
Column B to T has other data.
I would like to graph Column B vs Column A, and then be able to change the graph data to Column C vs Column A (with a macro), then to Column D vs Column A, and so on. and hopefully have a second macro to change DvsA to CvsA and then BvsA etc.

Ideally I would like a macro that would work for any selected graph/chart, where it'll change the selected data one column to the left or to the right.

Thanks.