Filling Area Between 2 Series in a Line Chart

[Tom]

Hello-

I have a chart with two series; one plotted on the Primary
Axis (assets-positive values), one on the Secondary Axis
(liabilities-negative values). There is an area between
the two lines that I would like to fill with a color or
pattern (this will represent the "free cash" that is
available).

Is it possible to have this area filled?

Thank you,
Tom

 

[Jon Peltier]

Tom -

You'd need the data on the same axis. Plot it as a stacked area type
chart, where the first series is Liabilities and the second is Assets -
Liabilities (but named Assets). Format Liabilities to have a border and
no fill, and Assets to have a border and a fill.

Alternatively, keep your line chart with Assets on the primary and
Liabilities on the negative secondary. Add a positive Liabilities
series and a Assets-Liabilities series to the chart, on the primary
axis, as stacked column series. Format the new liabilities series with
no border and no fill (the existing line series provide lines and
markers), and the assets-liabilities with no border but with the desired
fill color. You can hide unwanted legend entries by selecting the
legend with one click, select the legend entry text with the next, and
pressing the Delete key.

- Jon