View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Peter Shore
 
Posts: n/a
Default Excel - conditional formating on graphs. Change colour on a value

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.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting