Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i plot two different y-axis graph with same x-axis
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... ----------------------------------------------------------------------- "Zuhaib" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |