Plot Area

[2022]

I have a combo chart where the x axis on the left goes from 0-100.

But I want to format the plot area of the chart, so that anything above 80 in the plot area is green.

Anything between 50 and 79 in the plot area is orange.

And anything below 50 in the plot area is red.

I am not trying to format the indivual bars on lines in the chart - just the background, in different colours, depending on a threshold.

Does anyone know how to do this?

 

[duggie33]

Would a gradient fill in the plot area work? If you need distinct cutoff points, it might be able to be done with VBA.

Doug

 

[2022]

Thanks for your response.

But I’ll distinct cut-offs….do you know how to do that?

So in the screenshot you’ve posted above, assuming the top two rows were 80 and above, I’d want to make that plot area / background, green…

Then the 4 rows below that would be orange.

And the rows at the bottom would be red….

 

[duggie33]

You would change the gradient fill from linear left or right to linear up or down. Play around with the gradients; to make more distinct cutoffs, try adding more gradient points and have the transitions close to each other in the areas where you want the color to change. 0-49 would be red-red, 49-51 would be red-orange, 51-79 would be orange-orange, 79-81 would be orange-red, 81-100 would be red-red...experiment with it.

Hope that helps,

Doug

 

[duggie33]

I was able to get this with what I tried to describe above...

 

[2022]

I was able to get this with what I tried to describe above...
View attachment 101105

Thanks! That’s exactly what I’m looking for! Will test this out next week!

 

[duggie33]

No problem, glad to help. For reference, the gradients I added were positioned at 49, 50, 79, 80, and 100.

Doug

 

[2022]

No problem, glad to help. For reference, the gradients I added were positioned at 49, 50, 79, 80, and 100.

Doug

Ok, thank you!