How to fill the area between two lines in excel graph?

D

dypw2007

I'm trying to fill the area between 2 line graphs in excel. I need to
present the two lines in different colors, plus i need to add another line in
between the two lines. I tried using the "area" option in excel and while it
shaded the area between the line graphs, it did not allow me to add the extra
line in between.
 
J

Jon Peltier

The stacked area chart is used for the fill. For the three lines, add three
series of type Line. (Add them however they get added, which would be as
additional area series, then select each and use Chart menu > Chart Type to
convert to Line.)

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line fill graph. 2
Shading between two lines 1
graph column line graph with two axes 1
Two color fill between two lines 8
A line across my area chart 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Line Graphs 4
How do i show the gap between two lines of a chart 4

Top