Create a Bullseye chart with value thresholds
 

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?

Create a Bullseye chart with value thresholds
 

Hi,

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

Create a Bullseye chart with value thresholds
 

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

" wrote:

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?