Area Chart with negative value

[snowfamily1]

I need help making a stacked area chart that starts in the negative value range and extends up into the positive range. Here are the numbers that represent the stacks.


Qtrly Beg Q1 Q2 Q3 Q4 FY14
AOP 162 952 502 112 1,728
Worst Case 0 -977 -1,163 -2,691 -2,155 -6,985
Most Likely 0 0 790 960 4,327 6,077
Optimistic 0 0 231 694 2,777 3,702
Stretch 0 0 1 450 651 1,103
Total 0 -977 -140 -587 5,601 3,896


As you can see the chart starts at -6985 and then you add 6077 which extends that area up to -908. Here is where the tricky part starts. Adding the next value takes the value over the positive axis. I can get the chart to show this.

 

[SirJB7]

Hi, snowfamily1!
Something like this?
Regards!

 

[snowfamily1]

Thanks SirJB7 but that is not quit what I was looking for. Here is the chart I have been working on. My issue is with the Q4 area when it goes over to the positive values.

 

[Aurelie]

Hi Snowfamily1,

First of all, the series "Blank1" hides the positive values. (I deleted the series in the file I uploaded)
Secondly, there might be a mistake in the table you use as source for your chart, as Most Likely and Worst Case contain exactly the same value.
I uploaded a possible correction, but as I am not sure what you want to show, I don't know if this will work for you. What do you think?

Cheers,

 

[SirJB7]

Hi, snowfamily1!
Arriving late, Aurelie has yet done the job.
Regards!

@Aurelie
Hi!
Bienvenue chaque fois que vous pouvez me faire éviter de travailler
Regards!
PS: (Welcome whenever you can make me avoid working)