I have a data set for which I'm trying to create a partially stacked area chart.
One row of data has only positive numbers while the other three rows of data have only negative numbers. I'm trying to figure out how to include all of this data in the same area chart, but only stack the data from the rows that have negative numbers.
I've included a snapshot of the chart. I'm trying to stack the sections that are colored red, orange, and green, while leaving the blue section alone. Can anyone please assist?
One row of data has only positive numbers while the other three rows of data have only negative numbers. I'm trying to figure out how to include all of this data in the same area chart, but only stack the data from the rows that have negative numbers.
I've included a snapshot of the chart. I'm trying to stack the sections that are colored red, orange, and green, while leaving the blue section alone. Can anyone please assist?