Hi all, I'm trying to shade in between two lines one which is revenue and the other is cost over a period of time. Naturally they cross each other.
So far I have been able to show one in black when in "profit" and in red when showing a "loss". However, when they move from profit to loss there is an area to the right of the revenue line that is a mixuture of the black and red.
I am using a Combo chart type with rev and costs as line in Excel 2013. I have three variables: variance plus, variance negative and another variable called Starting value which is the same as revenue as Stacked Area. The starting value has a no fill.
Hopefully the above makes sense.
Thanks in advance for your help.
So far I have been able to show one in black when in "profit" and in red when showing a "loss". However, when they move from profit to loss there is an area to the right of the revenue line that is a mixuture of the black and red.
I am using a Combo chart type with rev and costs as line in Excel 2013. I have three variables: variance plus, variance negative and another variable called Starting value which is the same as revenue as Stacked Area. The starting value has a no fill.
Hopefully the above makes sense.
Thanks in advance for your help.
