
How Do I Make Multi Line Graphs?


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
Guys, I am having such a hard time making this graph. This graph I'm making is a multi line graph with 4 lines.
I am given 4 unknown gases each in a separate column with their two values for Temperature and Volume. But the main problem I am having is that, I do not know how to make it a multi line graph all on one graph because each unknown has different x values ( temperature ) and different y values ( volume ).
I don't know how to set up my cells for this.
Here is a short sample of the info I have on my chart that I need to graph.
eg.
Gas A
Temp,Volume
20,1950
40,1530
110,1095
180, 650
Gas B
Temp,Volume
42,1300
25,1100
60,750
100, 5
So you see, I am still very unfamiliar with excel. And as I showed above, both unknowns that I must graph have different x values.
With some samples I found on the internet, I was able to make a decent double line graph when the xvalues are the same. But, as I am repeating too many times, all my values are different.
Please can someone help?
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 ...
Charts: Line & X Y Scatter
 Learn when to use the Line chart and when to use an XY Scatter diagram. See the difference between the Line and the XY Scatter diagram Charts. Line ...
Math Function of X & Dynamic Charts
 See how to create a completely dynamic Math Equation System (Function of X) with Formulas, Data Points, Charts, and Chart Labels. Learn how to: 1 ...
Frequency Polygon Line Chart
 See how to create a Statistics Frequency Polygon using a line chart. Also, see how Excel mistakenly interprets number category label data as Number Se ...
Helpful Excel Macros
Get Values from a Chart
 This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Similar Topics
Is this possible to do in excel? I have a 3d graph created using (x,y,z) values in the form of a table. Now I want an estimate of the volume of that graph, something similar to calculating the integral of a 3d graph (area below the graph).
Is this possible to do? I'm thinking maybe using trapezoid rule but in 3D...
Thanks
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!
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?
Goal:
To over lay two charts, 1) a line or bar graph of average monthly temperatures for various cities; 2) a floating bar graph to represents a specific target range of temperature. To get this specific range for 2, I use a stacked column graph and delete the lower value.
My Problem:
When I select all the data (#1 and 2 above) to make the chart, I can't separate the two; the closest I can get is stacked or clustered column chart. What I need, however, is a stacked (#2) column graph (so I can delete the lower value) and a separate, overlaid graph (#1) for various cities' ave monthly temp (to see how they measure compared to the target range, #2). I can't simply drag a separate graph over the other, as the vertical axis values are different.
I'm using a Mac OS, MS Office '08 and can't seem to do this....when I do it excel takes all the data and puts them in a "clustered column" graph. I can't split the two up. That is, I want one
any advice/direction would be greatly appreciated! Thanks!
Hi All, this seems so simple but I can't rectify. I've got a line graph with two sets of values which are updated over time, a bit like a forecast and an actual. One set's fixed already and the other updates automatically. Where actuals don't exist, the cells in this data set carry null values.
In a line graph illustrating the two, the null values appear as zero on a line graph. How can I not have this illustrated. The only way to get rid of a line plummetting to zero is to delete the null values in the second set, which I can't do as the sheet needs to be automated.
Any help much appreciated as always!
I have a graph that has some data, and I want to make a heavy red line across the "0" axis. (The values of the graph go positive and negative.)
My first try was to draw in a red line using the objects, but when I do that, there are two problems:
1. I have to move it every time I rerun the graphs, which is daily, because the scale might change depending on how high or low the other values go.
2. When the red line looks fine on the screen, it prints slightly above or below the actual 0 xaxis when printed.
So... I put the red line in as a separate set of values, all with a value of "0", and made a line graph out of that. It is graphed on a secondary axis, and I just set the secondary axis to not have any tick marks or labels on it, so anyone who didn't know can't tell that the line is another graph. This works fine, except that the original dataset is detailed in a data table at the bottom, and it is still showing up with that data, but also with a dataset called "Zero Line". Is there a way to make that one line show up on the graph...but not be represented in the data table at the bottom? I need the original graph to continue to be represented, with values, at the bottom.
This should be easy to do but I can't figure it out.
I have two sets of data I'm trying to put in a line graph. They both have the same xaxis which is "date". And both sets of data even have the same values for date.
The yaxis is temperature and this is the only point in which they differ. However, when I graph in a series, only one set of data has the proper yaxis values. The other one is on the graph but it is not plotted at the right temperature points. How do I get both graphs to graph with the right yaxis values?
I have attached the chart.
Hey guys
I suck at excel. I'm suppose to make a line graph with the following data..I get the graph but the problem is that instead of making the volume the "x axis" it keeps making the cell number the x axis...So instead of starting at 0.75, it starts at 1 and ends at 46..These are the cell numbers not my x value PLEASE help, this is dua on monday
I have a series of lab values vs age. I can plot them on a graph and a line
forms between the values forming a curve though not symetrical. Since age is
a constant across the graph from 0 to 120 hours, is there a way to get Excel
to predict lab values for specific ages based on the curve generated on the
graph by the known values? If so, can someone help me through this? Thank
you.
Hi,
I have 3 different things that I want to graph vs. time on the same graph. I wanted to do a line graph but I would have to have three different yaxes for each set of data. Is is possible to graph all three in an intelligent way on a line graph? Or is there another graph that would work better?
I have created a pivot graph. It is a line graph, but often, but not all the time, when I go and refresh the graph data either on the graph or the corresponding pivot table, the graph turns into a column graph. This is Excel 2000. Is this an Excel glitch, or is there a way I can fix this so the graph stays a line graph? I have already written a macro that goes through each of the graphs and changes the colors and line weights. Perhaps I should build in to the macro some way of having the graphs refresh first, convert the graphs to line graphs whether they are or not, and then change the colors and weights. All the same, if there is an easier solution, I'm listening. Thanks as always,
I am not wellversed in excel to be sure....
I'm trying to make a line graph with specific increments on both the x and y axis. Now, I can make specific increments on one, but have to sacrifice the other in order for me to label the lines. Im not sure how to get around this. I'll just type out what i'm trying to do and maybe you smart people can help me here.
Okay, both the x and y axis must be in increments of 8,10,12.5,16,20,25,30, and 35.
The first line should be labeled "Indicated magnification, and should have the values 8,10,12.5,16,20,25,30, and 35... the same as the x and y values, making the line a straight linear line.
The second line should say "actual m value" and have values of 10,12.5,15.5,20.5,25,31,37.5, and 44.
The third line should say "actual n value" and have values of 10,13,16,21,26,32,38.5, and 45.
How do I set up a line graph like that? Again, any help would be very appreciated!
How do I select data for the 2 axis in a graph in excel. I mean I tried highlighting both set values and insert line graph. But I get 2 lines on the graph (each representing each set of values).
I want each set of data to be for one axis, with a resultant graph.
In my routine at work, I have to tabulate data in a spread sheet. I'm pretty inefficient at it and would apprecite some help or suggestions on how to stream line what I do.
So far, I have a tab in my spread sheet with all my data in columns: Clinical centers, thier hours, thier procedure volume, etc ...
I then have other tabs in the same file that populate the data into graphs for each column of data. There is a graph tab for hours, volume, drug costs, etc ...
The problem is that my boss likes the graphs to be shown in ascending order. What I have been doing up to this point is going in the master tab, arranging things by the particular column in data / sort and then printing out the corresponding graph.
Unfortunately this takes a lot of time and I find it frustrating. Like I'll arrange the main tab to list everything in ascending order based on procedure volume, right? That means the procedure graph looks perfect. I have to print that out and then go in and change the data to be arranged by drug cost. Now the drug cost graph looks perfect, but the procedure volume graph is all mixed up.
I was wondering if there were a more efficent way to handle this, either by locking a graph once I have it the way I want it to look, or by altering the data entry method. Any advice would be appreciated. I'm sure there is a simple solution to this  I'm just too noobish to see it.
This is probably a very easy question  but I can't seem to find this exact scenario in the forums or get it to work for me in Excel with trial and error.
My problem is this:
I want to have a graph with 3 noncontiguous sources of data. (No problem in theory, I just need to CTRL click the ranges)
The catch, is that one of my data series should always have a "zero" placeholder existing in the middle range. I would like this to be hard coded into the reference, and not rely on referencing a blank/zero range on a worksheet.
What I have right now is the following First and Last contiguous ranges:
=('Volume & Opex Graph Data'!$R$12:$AC$12,'Volume & Opex Graph Data'!$AD$12)
What I want to get is something like the following:
=('Volume & Opex Graph Data'!$R$12:$AC$12,{0},'Volume & Opex Graph Data'!$AD$12)
However, whenever I put "0", (0), {0}, '0', Excel always gives me an error. What's the correct syntax to accomplish this?
I have a line graph with 7 series. I tried changing it to an Area graph, but it didn't represent the values the way I expected. The values were higher.
Basically, I need a line graph with colored areas between the lines. Any advice?
Thanks!
I have a spreadsheet that will not seem to update a chart when new values are calculated. Auto or manual calcs don't seem to operate however making a change and then hitting undo seem to FORCE a recal and the graph updates. The values behind the graph seem to be functioning fine, but the line on the graph isn't updating.
Ideas?
Hi Mr. Excel,
I would like to plot a graph with a line whose width changes over time.
For exemple the level of the line would be the price of a stock and the width of the line would indicate the volume of traded stock.
I thought about ploting two lines and coloring the area between the two. Does anyone know if such function exist ?
(the graph is realtime, so the process has to be automatic)
Thanks
The question is simple, but I've tried long enough to know I won't find an answer myself.
Here it is : when I trace a line graph, if I put (in the graph values range)cells that contain formulas and whose result is zero or blank (i.e. sales for future periods of time), I get a line in the graph dropping down to zero.
Now, I would like that line to STOP at the last "nonzero" value in the data range, instead of dropping down to zero.
So that new values are shown in the graph only when the formulas' results become "nonzero" or "nonblank".
Is it possible? Have I made myself clear enough?
Thanks!
 Pse
Hi All,
One of my collegues has just stumped me with a graph question.
He has a basic graph with Values on the Yaxis, Months on the Xaxis and a Line 'Target' line across the middle (also on the Yaxis)
The problem is that the 'Target' line does not reach the edges of the graph as it plots to the middle of the first and last bar (ie where the 'value' is plotted)
Is there any way of extending these lines?
does this make any sense!
TIA
Dave
Hi Everyone!
I have a question about making a line graph with a phase line. I know how to make a graph, but I can't seem to figure out how to add the dotted phase line vertically down within the graph. I need it for a class assignment, and the teacher swears that she can do it in excel. Any suggestions?
Thanks!
I just created a graph for a row of data. Nothing major, just a line graph trending from 12 points of data in a row. Let's say row A.
So I have a graph that corresponds to row A, is there a way to make a new graph that pulls all the same data from row B, and row C and so on and so forth easily?
I feel like there is a simple solution to this and I'm just not familiar with it. Obviously I have to do this for over 40 rows of data, each one getting it's own graph, so I'm trying to figure out the short cut, rather than chart each range by hand over and over.
Thanks for your help in advance.
I can't seem to figure out a meaningful graph. Should I delete the percentages and make it a bar graph? How can I combine the two?
It's a month by month trend of Volume and % mix between three teams. I've tried all the traditional graphs and nothing seems to fit.
Any advice and or help/support would be great! One mind (mine) isn't enough it seems.
******** ******************** ************************************************************************>
Microsoft Excel  Book2
___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1
=
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
2
SOUTH
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
Volume
%
3
TEAM 1
346
65.5%
358
69.6%
356
69.8%
310
65.7%
282
68.1%
314
66.7%
333
71.3%
267
68.8%
212
58.7%
2,778
67.3%
4
TEAM 2
171
32.4%
133
25.9%
141
27.6%
146
30.9%
114
27.5%
142
30.1%
121
25.9%
109
28.1%
129
35.7%
1,206
29.2%
5
TEAM 2
11
2.1%
23
4.5%
13
2.5%
16
3.4%
18
4.3%
15
3.2%
13
2.8%
12
3.1%
20
5.5%
141
3.4%
6
7
TOTAL
528
100.0%
514
100.0%
510
100.0%
472
100.0%
414
100.0%
471
100.0%
467
100.0%
388
100.0%
361
100.0%
4,125
100.0%
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
Hey everyone,
I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?
Hi everyone. I was wondering anyone out there could help my with my problem.
I have this line graph and a known y value. With the following information, I want to determine the x value. In addition i want to label the unknown and draw a line to the slope. Is it possible to do so. If so what do i need to do?
my graph is attached below.

