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

Hi,

Conditional formatting will not automatically be applied to your chart.
You can however, with the use of additional data series, create
conditional charts.
See Jon Peltier's explanation.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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?