Create a Bullseye chart with value thresholds

[nujeruz76]

I need to create a chart that is divided into quadrants and have a
color associated with the area. If you fall into a certain data range
i.e., +/- 0 to 10% then you are green, +/- 11 to 29% = yellow, and
+/- 30% or greater = red. Can someone point me in the right direction?

 

[Carim]

Hi,

Take a look at Jon's brilliant solution ...
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html

 

[Guest]

Under format menu there is conditional formating that should do the job.