Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing every nth cell in a new column | Excel Discussion (Misc queries) | |||
Plotting multiple Y column data versus single X column in Excel 20 | Charts and Charting in Excel | |||
Plotting 3 column data as mutiple xy scatter plot lines on same graph | Excel Discussion (Misc queries) | |||
Referencing last populated cell in a column | Excel Worksheet Functions | |||
plotting data from column next to chart area | Charts and Charting in Excel |