Change Chart data range

Originally Posted by ArdusPetus

Could you please send a sample workbook ?

Thanks,
--
LR

Hi,

A macro that will convert data in "Chart1" to be the same data as in "Chart2" (if that macro is ran once). If that macro is ran twice, converts the data in "Chart1" reflects data from "column C". If that macro is ran again convert the data to "column D". And so on.

Similarly, a second macro that will convert the data from D->C->B, etc

Ideally both macros should be written in a way that they can be changed to manipulate "Chart2" instead of "Chart1"

The number of rows may vary from project to project, so the macros need to use the current number of rows from the current chart to figure out the new data range.
I'm looking to have a tool that I can use on multiple projects in the future to help quickly analyzing and comparing results graphically.

Any help would be appreciated.