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

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

http://peltiertech.com/Excel/ChartsH...kChartVBA.html

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



wrote in message
...
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