Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating Graphs (XY scatter Plot)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
Avoid plotting refferanced blanks as zeros in scatter plot graphs | Charts and Charting in Excel | |||
Generating graphs with less than results | Excel Discussion (Misc queries) | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
How do I plot a scatter plot in 3 axies? | Excel Programming |