View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

The easiest way to do this is to have a data series for the RED range,
another for YELLOW and another for GREEN. You can then create a "stacked"
column or bar chart. I'm assuming here that if you want a point in GREEN,
you won't also want it in RED.

"pcover" wrote:

I would like to create a chart where the color of the bar varies depending on
the point value. For example the range 0-1.99- red, 2.00 through 2.99 -
yellow, and 2.99 through 5.00 - green. Any ideas?