Conditional Charts:
http://peltiertech.com/Excel/Charts/...nalChart1.html

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


"Peter Shore" <Peter Shore@discussions.microsoft.com> wrote in message
news:5DA5CE6D-9234-4B47-AB8F-F3FB8E647110@microsoft.com...
> Excel - 2003 or previous.
> Conditional formating on cells is useful but I would like to see this on
> graphs as well.
> For example in a bar graph chart the series colour can be set either
> automatically or manually. A single data point can be set manually to a
> different colour.
> I would like to change a data point bar by condition / comparing to a
> value.
> The application is to 'flag' a data point by colour change if the value
> exceeds a certain comparison value.
>