conditional formmating data and put it into a graph...
 

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

conditional formmating data and put it into a graph...
 

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

conditional formmating data and put it into a graph...
 

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?