I want to make XY-plot using data of different worksheet in a single workbook.
Posted by Young Kim on September 16, 2001 10:04 PM
Hello, Everyone...
This is my first post in an urgent helps. I have data
series at two or more different worksheets, such as
sheet1, sheet2, and etc., in a one single workbook. I need
to make XY-plot using these data. Would you somebody show
me the way to do this job? Please look at the simple
example with which I want to make this job.
In sheet1
1 38
2 35
3 56
4 67
5 77
In sheet2
6 45
7 56
8 88
9 56
10 55
Please use my email < ytkim@fit.edu > for the direct
guide.Thank you for your help in advance. Sincerely,
Young Kim < ytkim@fit.edu >
Posted by Eric on September 17, 2001 5:48 AM
link to an earlier post inside
I think the following post
will be helpful.
To summarize, select the data you want to plot on the Y axis first, start the graph wizard, select X-Y graph, click next, and on "step 2 of 4" click the "series" tab and you'll see that the data range you selected is in the "Y values" box. Also notice that the "X axis" box is blank. Fill in that box with the reference to the data you want to plot on the X axis.
Hope that helps
