How do I create this graph in Excel?

[meredithtaylor]

Hello,

I'd like my graph to look exactly like the graph I pictured below. I'm trying to create an area graph to shade each range percentage listed below a different color.

• 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 the graph below to show exactly what I need it to look like. I've tired to create this graph using a million different data charts but am not able to get it to look exactly like the below.

Any help is greatly appreciated!!

!

 

[Fluff]

Duplicate to: Area Chart Help - Negative & Positive Values

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.