software

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.
peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
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 www.edferrero.com/charting.aspx

Ed Ferrero
www.edferrero.com

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