I have a simple Excel worksheet that updates with data by columns. I did the record macro, creating code for drawing the 1st graph based on Columns A,B&C. Then I need do loop on columns from C to EY. To draw the 2nd graph based on Columns A,B&D; 3rd graph based on columns A,B&E ;4th graph based on columns A,B&F ... till the graph based on columns A,B&EY. I'd like all graphs to be on another sheet.
I've tried several suggestions online and played with different codes. However,it was totally a mess. Any help on how to fix this would be greatly appreciated!
Thanks a lot!
I've tried several suggestions online and played with different codes. However,it was totally a mess. Any help on how to fix this would be greatly appreciated!
Thanks a lot!