Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to fill the area between two lines in excel graph?
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. |
#2
|
|||
|
|||
Answer: How to fill the area between two lines in excel graph?
By following these steps, you should be able to fill the area between two lines in an Excel graph and add an extra line in between.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to fill the area between two lines in excel graph?
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dypw2007" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I used two different colors in an excel graph plot area? | Excel Discussion (Misc queries) | |||
How do I calculate the area under a curve in an Excel graph? | New Users to Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel | |||
Is there a way to have the plotted area of an excel graph to have. | Charts and Charting in Excel | |||
finding the area under the curve in a graph in excel | Excel Discussion (Misc queries) |