how can i plot two different y-axis graph with same x-axis

[Zuhaib]

Hi
I am plotting two Y-axis graphs having two series bit with different Y-axis
and even number of data of X-axis is not same using option the XY (Scatter)
with data points connected by the smooth lines. The data for first series is:
Days Commulative Gas Prodcution (mL)
0 0
1 0
2 0
3 0
4 0
5 0
6 3
7 28
8 29.6
10 35.6
13 41.2
14 43.8
15 51
20 53.1
22 57.2
25 58.3
30 61.5

And second series data is
Days TCOD
0 39285.71429
1 28571.42857
2 25000
3 21428.57143
4 21428.57143
5 22857.14286
6 23214.28571
7 12500
14 17857.14286
30 14285.71429

I have plotted it but the problem is that i don't have same number of points
for x-axis even thought i am taking the primary x-axis and secondary x-axs
differently. But the graph of first series is chopped upto the second series
if i am taking primary x-axis related to the second series and if i am taking
different primary and secondary x-axis, for the second series data it comes
upto the 9 points and even the x-axis is behaved as number starting from 1 to
30. please solve this problem. I will be thankful to you guys.

I hope you would have understand it i am using Excel 2003.

thanks
Zuhaib

 

[Earl Kiosterud]

Zuhaib,

You weren't real clear on the X data part, but I think you probably need to check the cell
references for your series, since you have separate X data for your series. The chart
wizard tends to use your first column for the X data, and each of the next columns for Y
data for a series. Right-click your chart, choose Source Data, and go to the Series tab.
There should be 2 series in the series list on the left. If there are more, select one and
delete it. Now click each series, and set the X and Y reference boxes to the correct rows
or columns of your worksheet. They're RefEdit boxes, so you can just drag through the cells
on the sheet.

To change a series to a different Y axis, right-click one of the data points and choose
Format Series. Axis tab. Select Secondary, and another Y axis will be built, and the
series will use that axis.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...