Hi confused19,

As well as Jon Peltier's method, you can use VBA to apply limited
conditional formatting to charts.
See 'Conditional Chart Formatting' at http://www.edferrero.com/charting.aspx

Ed Ferrero
http://www.edferrero.com

how do i take conditional formmating data and put it into a graph
according
to its category?