Area Chart Help - Negative & Positive Values

[meredithtaylor]

Hello,

I'm trying to create an area graph to shade each range percentage listed in the far left column (pictured) a different color.

• Rage A - shade anything above 15% one color
• Range B - shade 5 - 15% a different color
• Range C - shade -10 - 5% a different color
• Range D - shade anything below -10% a different color

I'm having issues with range C, for some reason it is not wanting to shade both a positive and negative region. Range C is not showing up on the graph at all.

I have included an image for reference. The goal of this chart is to show where the "Data" (the black line line on the graph) falls in the A,B,C & D ranges.

Any help is appreciated! Thanks!

 

[Jimmypop]

Hi and welcome...

Should it look something like this?

 

[meredithtaylor]

Hi and welcome...

Should it look something like this?View attachment 69257

Hello,

I'd like my graph to look exactly like the graph I pictured below. I need the A, B, C & D ranges to be filled in for the below percentages.

• Rage A - shade anything above 15%
• Range B - shade 5 - 15%
• Range C - shade -10 - 5%
• Range D - shade anything below -10%

I need the A, B, C & D ranges to be the exact same across lines 1, 2, & 3

I also need a separate "DATA" line that is a line graph that plots the below percentages across lines 1-3.
Line 1 : -10%
Line 2: -20%
Line 3: -15%

What does my initial data chart need to look like to replicate this graph? I had to photoshop range "C" in the below image because I was not able to get the area to fill both negative & positive percentages (-10% - 5%).

 

[Jimmypop]

Will have another look... Your original Range D color was over Range C ( so basically the fill color for C was hidden behind D) that is why with my suggestion I made the fill color of D no fill and just gave it a border so one can see Range C color... Will investigate another approach. .

 

[meredithtaylor]

Will have another look... Your original Range D color was over Range C ( so basically the fill color for C was hidden behind D) that is why with my suggestion I made the fill color of D no fill and just gave it a border so one can see Range C color... Will investigate another approach. .

Thank you, I appreciate the help!

 

[Jimmypop]

Thank you, I appreciate the help!

Hi Meredith

I have been trying to do this and below is the closest I am getting. the issue with the area chart and your data set is that the colors keep overlapping which causes one to be behind the other. One cannot separate them as with lets say gap width and series overlap as with a column chart. What I ended dup doing was play around with the colors a bit and then setting the fill color for Range D to 50% transparency. Other than this not sure how to accomplish it. maybe someone else has a suggestion?