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?
Dear Archana Patil,
Even I can't get you. Are you talking about Lines in Drawings or in Charts or somthing else?
The solutions would differ as per the requirement.
If it is a chart, then use the solution which Jon Wittwer has provided.
Can you explain your requirement in detail?
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
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.
I can't get you.
Can you explain in detail?
