Generating Graphs (XY scatter Plot)

[lijia137]

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

 

[Jon Peltier]

This page might help you get started, especially with cleaning up of
recorded code:

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

Your procedures will be easier if the X column is to the left of the Y
column.

- Jon