plotting multiple data columns on different graphs (same style) with a loop?

[chemeng1T3]

Hi,

I have a graphing function that's very long that i'm trying to shorten...it runs off a command button and a combo box where i select the sheet that i want to use for data (all the sheets are formatted the same).

The data columns I want to graph are all next to each other, in columns VN:WD. Rather than writing out a "add chart" command for each column, I was wondering if there was some way i could add a loop to my code and just write one "add chart" command rather than 18.

Please Login or Register  to view this content.

Thanks a lot!

[chemeng1T3]

does anyone know if this is even possible to do?