Chart plot background color.

[AndrzejL]

Evening,

I have a question for you guys and girls.

I am working on a chart that looks like this:

https://s7.postimg.org/puskz7m5n/Untitled.png

Now my question is: Can the chart plot background be split into a 3 colors depending on their value?

I have 3 different criteria 0 - 25000 - satisfactory - I would like that part of the chart to be green, 25000 to 500000 - acceptable - orange and finally 500000 to 50000000 - unacceptable - red.

Something like this:

https://s18.postimg.org/vtno9ttw9/Untitled.png

I would preffer for the background to be transparent so that the chart line is clearly visible.

Thanks in advance for any help provided.

AndrzejL

 

[AndrzejL]

Am I out of luck on this one?

AndrzejL

 

[AndrzejL]

Sorry for bumping this thread but this is really not letting me sleep... Does ANYONE knows how to achieve this?

Cheers.

Andrzej

 

[thisoldman]

Jon Peltier has a tutorial, "Excel Charts With Horizontal Bands":
https://peltiertech.com/excel-charts-with-horizontal-bands/

 

[AndrzejL]

Jon Peltier has a tutorial, "Excel Charts With Horizontal Bands":
https://peltiertech.com/excel-charts-with-horizontal-bands/

I am going to try it straight away... You're possibly a life saver!

Regards.

Andrzej