Generating Graphs (XY scatter Plot)
i'm tryingt o generating graphs out of my worksheets, all graphs are
catching data from the same columns (column C is Y axis, column D is X
axis, I;m trying to write sth that will catch this two columns
automatically once i'm swiching to new worksheets.
I did macro recording, but it goes to one specific worksheet only, i
guess i'll hv to change the specific worksheet to activeworksheet? am
i in the right direction? Pls advise. many thanks
|