Colouring in between lines

[MikeJ100]

Hi all, I have a chart showing revenue and costs by month. There are some months that rev is greater than cost and other months when the opposite is true.

I wish to shade in between the lines e.g. when cost is greater than rev red, whilst when revenue is greater than cost say green.

I have tried using a stacked area graph, though in certain instances the shading is outside the lines.

I am using Excel 2016.

Thanks for your help.

Mike

 

[Cross Terrier]

Does this help? It's not for Excel 2016, but may just require tweaking.

https://peltiertech.com/fill-under-between-series-in-excel-chart/