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
Bookmarks