Thread
:
Excel - conditional formating on graphs. Change colour on a value
View Single Post
#
2
Posted to microsoft.public.excel.charting
Jon Peltier
Posts: n/a
Excel - conditional formating on graphs. Change colour on a value
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
wrote in message
...
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.
Reply With Quote