
Plotting A Graph With 2 Yaxis And Different Data Sets


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
Plotting A Graph With 2 Yaxis And Different Data Sets  Excel

View Answers


Hi,
My Xaxis is year 20002010 and I need to plot house prices up one Yaxis and Volume of sales up the other Yaxis so the two can be compared on the same graph. I am having trouble doing this, can anybody help me?
Similar Excel Video Tutorials
Frequency Polygon With 2 Or More Line
 See how to create a Frequency Table. Then see how to calculate the midpoint of each category and make a Frequency Polygon with two or more lines (two ...
Similar Topics
I am TRYING to plot a graph for Economics with 'Output' on the X Axis (1,2,3...10) and $ (0,50,100...300) on the Y Axis. There are 3 Lines on the graph using this data (eg. Total fixed cost, Total variable cost, Average variable cost) but then I need to put a 4th line on the graph for Marginal Cost  using the same Y Axis values, but plotting on the X axis at 1.5,2.5,3.5...9.5. I don't have these values for the other 3 lines that I am plotting though so end up with a graph that is completely wrong. Is there anyway I can plot this 4th line without messing up the rest of the data?
Any help is much appreciated!!
I feel like a total noob
I'm trying to plot a graph with 3 series on yaxis, and a value xaxis (i mean, not category). One of the series is very different in scale, so it needs a second yaxis to the right of the graph. However, i can't seem to get both a second yaxis and valuetype xaxis.
I can get the series right when i select multiple axis graph, but then the xaxis assumes the category view, which doesn't line with the plot points at all..
Any help is greatly appreciated, thanks in advance.
when i choose to use the logarithmic graph/chart, it changes the yaxis but leaves the xaxis to remain for use with my own data. what i want to do is have both the x and y axis' present themselves in the logarithmic form but then be able to plot points on the graph that fall between both the x and y axis values. it has been a couple years for me and this is a lot of refresher course for me lol. any help would be greatly appreciated, even if it does prove not to be possible to do as i wish.
thanx,
jeff
Hi everyone,
I'm trying to do what seems to be a simple graph but i can't get it right!
I have the following data:
Col A Col B Col C
1.3 0.01 0.01
1.27 0.01 0.01
1.25 0.01 0.03
1.23 0.01 0.05
1.2 0.01 0.07
I need to get Col A as the yaxis and plot ColB and Col C on the xaxis using line graphs
The closest i got to is as the chart below, but i need the axis to be inverted, like turning the whole graph 90degrees clockwise.
any help pls?
Thanks
Hi,
I hope you are having a good day. I need some help plotting a graph which i am not sure how to go about doing so.
I am looking to plot a graph with 3 axis i.e. xyz AXIS.
xHeight
yErgo_Index
zDistance
I also want to plot the mean, standard deviation +/ of the Ergo_Index on the same graph.
I have attached the data and would be most greatful if someone could either point me in the right direction or help me plot this and explain how it is done to me.
Thank you
Hello,
I am undertaking my final year report at university, where i am required to plot Young's Modulus, Ultimate Tensile Strength and Elongation at Break on the same graph (all as the yaxis) with material type as the xaxis.
These three groups of data need to be displayed on the same graph, one set of data is 1,000,000,000's (GPa) another in 1,000,000's (MPa) the other in % (elongation).
the three variable's are plotted on three yaxis (all on the left).
I know how to plot a graph with a secondary y axis (one y on the left one on the right) but not when it comes to a third axis.
any help anyone can give me would be much appreciated...and you will get a mention as a thank you / contributor on my work if you wish!!
Many thanks in advance,
Phil H. Loughborough University
Hello all!
I have to create a graph with two variables on the left Y axis and one on the right Y axis while showing the year on the X axis. However, whenever I try to create a graph it shows the year as a line on the graph and it just has 1 2 3 4 5 6 7... etc, on the X axis.
I've done this a few years ago, I just can't remember how to insert the year on the X axis so it won't show up on the line graph.
Here's how I am selecting my data before I select the graph:
YEAR  2004 2003 2002 2001 2000 1999 1998
CBR  11 12 13 14 15 16 17
CDR  6 7 8 9 10 11 12
POP  213 231 232 232 231 213 287

Is that the right way of putting my data on the excel grid before I hightlight it and selecting my graph?
Thank you and any help would be greatly appreciated!! icon_biggrin.gif
CJordani
Hi,
I have a data table. C42 to C46 are growth rates (g) while D41 to H41 are WACCs(weighted average cost of capital). The rates in C42 to C46 are 2.0%, 2.5%, 3.0%, 3.5% and 4.0% while that rates in D41 to H41 are 6.0%, 7.9%, 9.5%, 9.9% and 10.9%. From D42 to H46 are stock prices. For example, D42 is 5.50, E43 is 3.40, etc. My question is that if I plot the values in C42 to C46 as the Y axis and the values in D41 to H41 as X axis, what can I do to plot the values in D42 to H46 in the graph? That's to say there are 25 data points (not including X axis and Y axis) in the graph. For example, the data point 5.50 corresponds to the 2.0% on X axis and 6.0% on Y axis.
Thank you guys!
Hi, I need help creating a specific line graph. What I'm trying to do is graph results from an experiment (measuring the volume vs mass of an object in different amounts). So how I'm trying to graph it is this: Put the volume on the yaxis and the mass on the xaxis, then put in the results accordingly. So for one point say the object had a mass of 20 and a volume of 40, it would be on 20 on the xaxis and 40 on the xaxis. The problem is, when I try to graph this I cannot change the xaxis to a dependent variable (it always comes up as values like 1, 2, 3, 4, 5). Can anyone help me?
I have two data series, one for 'this month' and one for 'year to date'. I am plotting these in a clustered column type graph. I am try to plot the 'year to date' series on a secondary axis but whenever I select the series and use 'format data deries' 'axis' 'plot series on  secondary axis' the graph converts to a stacked column. I am using Excel 2003 via a thin client to Windows server 2003.
Hello. I am fairly handy in using Excel but I am stuck on a graph problem.
I am essentially trying to graph a US yield curve that has the following x axis year points: 0, .08, .25, .50, 1.0, 2.0, 5, 10.0, and 30.0. When I create the graph using values for the y axis, the x axis is uniformally scaled such that my 5 year point looks like it is 2/3rd the way down the curve instead of where it would be... .16 down the path on the x axis. How do I control (or scale) the xaxis so the points plot where I want them instead of uniformly being distributed as is the default case. I do not want to create "dummy" interpolated points to trick the xaxis based on all the different ways I will be shaping the curves I need to graph.
Thanks in advance for the help.
John
I need to make a bar graph as background, with a line graph to indicate another value.
basically I've got these three tables:
Xaxis
31
32
33
34
35
Yaxis, in bar graph form
27,109
22,024
15,771
25,699
17,828
Yaxis (would prefer axis on right hand side of graph), line or singular points marked on the above bars
(The scale will be different ofcourse  30 thousand to 5 makes a big difference, however how the scales are compared (like 6000:1) doesn't really matter)
3
1
2
4
1
I want these values combined in one graph if this is possible.
Could someone help me out here?
I can do the bar graph, however how do I add the last 5 values in the graph?
Thanks in advance!
Greetings,
I have two questions regarding graphing:
1) I have two sets of data (with the same xaxis data) on my graph and for the first part of the graph both sets are equal  data set "a" is red for example and set "b" is blue
where both sets are equal I have it as red  how can I pull the other set to the top so that where both sets are equal is the color of the second set?
Even changing colors does not fix it I want set "b" on top  it's actual data and "a" only to be seen when it differs from "b"
2) With 2 sets of data  each data point corresponds to a month on the xaxis  I have one set of data that goes back to year"2000" for example and the 2nd set of data only goes back to "2004" how can I plot set 1 from 2000 to present and set 2 starting at 2004 and lined up with set 1?
When I try to plot both sets it starts set 2 back at the origin.
Meaning I want to start the plot of one set shifted on the xaxis to the right.
Thanks
Sparky_
hey, im not too good on excell hence the post, btw im on 98 version
basically i have 2 sets of data
eg.
HeartRate ..... Oxygen Uptake
101 .................... 1
102 .................... 2
103 .................... 3
I want to plot these points on a set of axis,
the xaxis being HR and the yaxis being O2.
I want the xaxis to range from 0  220 (with 202 being a point) in 10 increments.
and the yaxis to range from 03 in 0.1 increments.
i then want to (after setting the points from the table above on the axis) plot a linear regression line, which extends to the 202 and have dotted lines pointing to the Oxygen value.
is this possible because i have been trying it for ageeeeees
Hi everybody
I have 4 columns, Say H1, T1, T2 and T3. H1 is height, where Ts are temperatures. I have to plot all the three Ts on the graph (Xaxis) against H1 (Yaxis). Lets name the resultant lines that we obtain on the graph as:
H1 Vs T1; L1
H1 Vs T2; L2
H1 Vs T3; L3
Now the purpose of doing all this is to know the value of H (Yaxis) on the points where T2 (Vs H1) and T3 intersect the T1.
Is there any technique/macro to do that? Because i have got around 4,000 sets of data to do this same thing.
Peace.
Hi  Can someone tell me how to plot non metric measurments on a graph. e.g. a graph that has stones, pounds and ounzes on the y axis opposed to the metric 110 etc for kilograms. Alternatively how to plot miles and yards on the y axis apposed to kilometers and meters. I am trying to plot a graph for weight that shows stones, pounds and ounzes on the y axis with weeks on the x axis.
Thank you
hi ,
I am trying to plot different lorenz curves ( with different percentage bases ) in a single graph...the xaxis represents the percentage cumuilative number of firms and the y axis represents the percentage cumulative output.
if i have 20 firms, then the xaxis will be 1/20 , 2/20....20/20 >( 0,5%,10%...100%)
if i have 19 firms, then the xaxis will be 1/19, 2/19...19/19 ...evidently this is differnet from the one above...how can i plot both in one graph?...or can't i?
thx for any help!
Alright, I'm plotting a graph with two sets of data. I have a longer set of data for my Y axis than for my X axis. Is there a way to extend my data either in the graph or in the spreadsheet that will create data so I can plot all my values of Y. Is there a way to make a forumla that recognizes a pattern in my X axis data so Excel can continue the sequence for me? The data is exponential.. if that helps.!
Thanks in advance and let me know if I need to post anything else to clarify..
Hi,
I am trying to plot the data below on a graph, but as you see the X axis is not to scale. Every time I plot the graph it always starts at 0 instead of 2.2. I have tried to fix this by inputting X axis values to a fixed scale and putting the Y axis values next to the relevant values but when i do that the line for the graph does not show. How can this be done?
X axis____Y axis____Y axis
pH_____ Immob___ Free
2.2_____0.172______0.42
3_______ 0.454_____ 1.39
4_______ 0.796_____ 1.74
6_______ 0.738_____ 1.43
7_______ 0.45______ 1.034
8_______0.292_____ 0.602
9.2______ 0.18______0.418
10 ______ 0.066_____0.138
Hi Community!
I am trying to plot in a 2 yaxis graph 4 series of data (lets say a,b,c,d). The first 2 series (a,b) I want to have in bars according the primary yaxis and the other 2 (c,d) I want to have them as lines following the secondary yaxis.
I can do it, HOWEVER, the second line I plot (d) is shown as an accumalated value together with c (c+d). Why does that happen? Can anybody help me on plotting the second line (d) with original values?!
Thanks a lot community! :)
Best
Patricia
Hi All,
I want to know about graph which has z axis.
Z axis Graph : What are the uses.
Examples. or links where I can learn to draw the graph with z axis.
I am not talking about graph with secondary axis.
I know how to draw a normal graph.( graph with X & Y axis.)
Regards,
Sushant.
Please help,
Hi
I have a problem with Data on a graph.
3 lines of data
2 should plot on graph and the other is where the data exists, although this is being used as the x axis. I need the x axis to go from 0  3 and not
X Axis  Plot 1  Plot 2
0 100 0
0.125 99.75 0.25
0.18 99.22 0.78
0.25 97.42 2.58
0.355 94.63 5.37
0.5 92.46 7.54
0.71 89.25 10.75
1 83.8 16.2
1.4 70 30
2.8 32.3 67.7
its not going up in scale like it should do. The points are appearing as the values I have typed in column A, which is right. But they don't go up in the right scale on the x axis.
I can send anyone the spreadsheet if you can give me an email address, please email me @ 27hiltonheights@gmail.com
thnaks,
N
hi,
i have 2 sets of data like
Code:
x y1 y2
1 7.784961119 514
2 0.658580208 722
3 7.420948746 143
4 6.329237303 716
5 1.819070998 157
6 3.597455694 917
7 0.151490199 701
what i would like to do is plot both y1 and y2 on one graph, with 1 common xaxis, and 1 common yaxis (i dont want to activate secondary axis). however, i want to cut the yaxis into 2 unrelated halves, where 1 half will 'accommodate' y1 and the other for y2. the final overall plot will have, say, y2 floating on top of y1, with only 1 common xaxis (something like 2 separate plots stacked vertically, with only 1 xaxis visible). is that possible?
Hi,
I have automated plotting of charts of date v/s speed recorded on a
particular day with date on the xaxis and speed on the yaxis for each car
that is being tested say Focus, Escort and Ikon. The graph gets displayed
properly for the first data selected
(say Focus) from a combo box. Now, for the other selection, the graph axis
are getting reversed i.e date is getting plotted on the yaxis and speed on
the xaxis !
Is there some why to control this ?
Iâ€™m using Excel with VBA.
TIA
I have created a graph with the x axis being years from 0.0 to 30.0 (an interest rate graph with year points 0.0, .1, .3, .5, 1.0, 2.0, 3.0, 4.0, 7.0, 10.0, 20.0, and 30.0). And the y axis being interest rates. When the data points and legend displays, the years on the xaxis are not displayed where they should be.... they are unifirmally spread out from 0.0 to 30.0 instead of mathematically where they should be. Example 4.0 is the 8th data point so it shows 2/3rds down the axis instead of 4/30 on the axis. I fixed this problem before but can't remeber again how to do so. Thanks in advance for the help.
John

