Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
How do I plot value on x axis and category on y axis? | Charts and Charting in Excel | |||
How to plot chart with 2 different y-axis with a common x-axis? | Charts and Charting in Excel | |||
dot plot - single x axis location with multiple y axis dots | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |