View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zuhaib Zuhaib is offline
external usenet poster
 
Posts: 1
Default how can i plot two different y-axis graph with same x-axis

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