Stacked Area Chart - Negative Values

Hi,

I have a stacked area chart (Chart 2) which I have generated in Excel, please see the attached image illustrating this.

The problem is as follows:

Chart 1 and Chart 2 use the same data, however Chart 2 in done so in Excel.

How can I preserve the negative values in the stacked area chart in Excel? Essentially I want Chart 2 to replicate Chart 1.

I am happy to use a macro if need be.

Many thanks in advance.

Sagar