Forum Discussion
how to Fill area in between lines
I want to fill area in between two lines? Line option from ad in tool is appropriare or not to do the same?
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". The first series of the Stacked Area Chart is the data for the lower line. The second series for the Stacked Area Chart is a new data set that you define as the values for Line 2 minus the values for Line 1.
After creating the stacked area chart, you can copy your data for Line 1 and Line 2 and paste into the chart, then go to Chart Tools > Design > Change Chart Type, choose Combo from the list of All Charts, and choose Line or Stacked Area for the different series.