Problem in plotting 2d area chart for -ve values

**Debasish Nath** · 08-20-2021, 08:39 AM

Please find the attached worksheet. I want a plot like figure 1. In which I have 3 series of data. I want the shaded portion as well as the mean data series to be shown as in figure1. For that I have created 2d area charts for data series named 'UB' and 'LB' . Then I have filled the unwanted below area with white colour.

But in Figure 2 I have negative values in the data series. So the area chart coming inverted. How to plot this like Figure 1?

Please help.
I am new to Excel and finds it difficult to do.
It will be of great help if anyone can plot it in the same worksheet?

Thank you
Debasish
Attached Files

**alansidman** · 08-20-2021, 10:40 AM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: