Impressive Excel Chart Area Between Two Lines
Only if you have numeric labels empty cell A1 before you create.
Excel chart area between two lines. I attach the excel file with the graph. The protocol for filling between two plotted lines is pretty much the same as above. Insert Scatter with Straight lines chart and mark intersection point Right click on lines Format Data series Marker Options Fill Excel.
Sep 3 2015 1 Hello I have a graph with two lines representing the scheduled and real production. More of a work around than a solution. In the Select Data Source dialog box click the button to add a new data series for the Minimum my Min series is in cells O6O17 with Name in O5.
The Gap column calculates the difference between the Top and the Hidden Base E2-C2 E3-C3 etc. Scroll down to find the section Fill Between Two XY Series. Thanks in advance.
Probably the easiest method I know of is to use a stacked area chart where the fill of the lower area is set to no fill. Rav_rav asked on 7112014. Below is an image showing the issue.
Move chart line to front by moving series location. We will also need two stacked area chart series one for the clear region below the lower XY line and one stacked on top to fill between the XY lines. Select the entire data set A1 through F8 and create a Stacked Area chart.
Reformat the Min line by changing it to an area. Notice how the x-axis has Period as a label. The months are on the X Axis and the dollar values are on the Y axis.