rav_rav
asked on
Fill an area between two lines in a chart in Excel
Hi Experts,
On the website below, it shows how to fill an area between two lines in a chart in Excel.
http: //superuser.com/questions/
I'm trying to use the above example to plot a graph of Revenue vs. Expenses on a monthly basis, and I'd like to colour the area between the lines to show the gap.
Is it possible to have two different colours for the areas between the lines though?
If Revenue line is greater than Expense line, I'd like to have the area coloured green. If Revenue line is less than the Expense line, I'd like to have the area coloured red.
Thanks
On the website below, it shows how to fill an area between two lines in a chart in Excel.
http: //superuser.com/questions/
I'm trying to use the above example to plot a graph of Revenue vs. Expenses on a monthly basis, and I'd like to colour the area between the lines to show the gap.
Is it possible to have two different colours for the areas between the lines though?
If Revenue line is greater than Expense line, I'd like to have the area coloured green. If Revenue line is less than the Expense line, I'd like to have the area coloured red.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No answer posted
Jon Peltier has two articles that might be helpful to find your optimal approach:
Fill under or between series in an XY chart
http://peltiertech.com/WordPress/fill-under-between-series-in-excel-chart/
and
Area Chart – Invert if Negative
http://peltiertech.com/WordPress/area-chart-invert-if-negative/
For your scenario, the second option might be a better fit.
The articles are a bit too long to quote here. Suffice it to say that in both approaches a stacked area chart is used to create the illusion of a fill color between two lines.
Let me know how you get on and if you need more help with the approach.
cheers, teylyn