Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How Do I Make Multi Line Graphs?

Forum Register
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.


Gas A
-180, 650

Gas B
-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 x-values are the same. But, as I am repeating too many times, all my values are different.

Please can someone help?

View Answers     

Similar Excel Tutorials

How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
I'll show you how to create a message box popup window in Excel that contains text on multiple lines.  This allows ...
Copy one range and paste in another range
Below is a macro, just copy and paste it into a module in your workbook and go from there.This macro uses message b ...
Loop through All Worksheets in Excel using VBA and Macros
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only take ...
Ignore Blanks in a Data Validation List in Excel
I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel. All 3 methods are multi ...

Helpful Excel Macros

Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
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
Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt

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...


I need to make a bar graph as background, with a line graph to indicate another value.

basically I've got these three tables:


Y-axis, in bar graph form

Y-axis (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)

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 y-axis and the mass on the x-axis, 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 x-axis and 40 on the x-axis. The problem is, when I try to graph this I cannot change the x-axis to a dependent variable (it always comes up as values like 1, 2, 3, 4, 5). Can anyone help me?

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 re-run 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 x-axis 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 x-axis which is "date". And both sets of data even have the same values for date.

The y-axis 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 y-axis 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 y-axis 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

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 y-axes 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 have several sets of data containing different values (#, % etc). problem is, i want to produce 1 graph that can show all the datasets using line graph. currently, i have to produce several line graph and combine it into 1 (see sample attached).

any faster way to do this?


Hello again,

I just joined this forum and everyone has been extremely helpful! I am back with another question. I am trying to create a 3-axis graph, combining a stacked column graph with a line graph above. As for the column graph, the X-Axis is labeled "Year" with 2010-2013. The stacked bar graph represents the number of transactions that took place in each county for a given year (Counties stacked on top of one another, each represented by a different color.) The Y-Axis label is currently "number of transactions". I would like to plot total sales volume above the stacked column graph as a line. There will be one line for each county, each data point representing the total sales volume for that county in a given year. I would like to make the other Y-Axis label "sales volume". Does this make sense? I am having trouble uploading examples.

Below is the table I have used to create the stacked column graph, which works perfectly. I just can't figure out where to add the sales volume figures for each county to get it to plot above in a line.

County 2013 2012 2011 2010
Los Angeles 4 14 15 11
Orange 0 3 0 6
Riverside 1 0 0 0
San Bernardino 0 3 0 0
San Diego 0 3 1 0
Ventura 0 0 2 1
Totals 5 23 18 18

Below is the table I am using to create the line graph, this also works perfect. Any help would be much appreciated!

County 2013 2012 2011 2010
Los Angeles $314,550,000 $787,005,909 $932,985,440 $653,238,960
Orange $0 $139,900,000 $0 $375,600,000
San Bernardino $0 $213,475,000 $0 $0
San Diego $0 $253,850,000 $80,400,000 $0
Riverside $58,000,000 $0 $0 $0
Ventura $0 $0 $130,100,000 $81,500,000

I am not well-versed 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!

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 non-contiguous 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 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.


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 real-time, so the process has to be automatic)


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 "non-zero" 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 "non-zero" or "non-blank".

Is it possible? Have I made myself clear enough?

- Pse

Hi All,

One of my collegues has just stumped me with a graph question.

He has a basic graph with Values on the Y-axis, Months on the X-axis and a Line 'Target' line across the middle (also on the Y-axis)

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!



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?

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.

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.

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

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?