is there a conditional xls chart (ie change the graph dot color)?

how do i setup a conditional xls chart? for example the individual points at
the chart color changes w/ the condtion (ie if it is below 90, turn red, if
it is above 90 trun green, etc)?

kindly,

b. lee

Have a look here for details.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

bribri wrote:
> how do i setup a conditional xls chart? for example the individual points at
> the chart color changes w/ the condtion (ie if it is below 90, turn red, if
> it is above 90 trun green, etc)?
>
> kindly,
>
> b. lee

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info