Format Chart based on data
 

I have built a chart from a simple spreadsheet of data. Here is an example
of the data:

Group1 13.77
Group2 15.86
Group3 12.11

I want the chart (bar style) to show each bar in Blue that corresponds to a
value greater than 13. All other bars (<13) should be red.

Is that possible?

Also, I want to draw a line across the chart at 13 to show the "benchmark".

Format Chart based on data
 

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

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


"marcus" wrote in message
...
I have built a chart from a simple spreadsheet of data. Here is an example
of the data:

Group1 13.77
Group2 15.86
Group3 12.11

I want the chart (bar style) to show each bar in Blue that corresponds to
a
value greater than 13. All other bars (<13) should be red.

Is that possible?

Also, I want to draw a line across the chart at 13 to show the
"benchmark".