cell/column referencing and plotting data
 

Hello,

Can you please help me with referencing cells. I want to do the
following:
1. say an excel file with the following data arrangement:
Column B and C have numerical data
column E and F have numberical data
and so on. The number of such columns is not known beforehand. I want to
write a macro that will take the first two columns and treat column B as
X-axis and Col. C as Y-axis and do an XY plot. The go to column E and F
and do the same and repeat this till all the columns are exhausted in
the whole sheet. I want all those plots to appear on a separate Chart
and formatted in such a way that there would be say 6 graphs per page on
the final layout. ( I do not want to overlay the plots. They should be
separate).
Please help. Thanks

Srikanth



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!