How can I vary graph color by range value

[pcover]

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?

 

[Barb R.]

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.

 

[Tushar Mehta]

The following link does two colors. Extending it to 3 should be pretty
straightforward.

http://groups-
beta.google.com/group/microsoft.public.excel.charting/browse_thread/thr
ead/124801ec8fec8ba7/f72d941a0711c714?q=conditional+chart+group:
*Excel*+author:tushar&rnum=24&hl=en#f72d941a0711c714

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Here's another conditional chart example:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______