Hi,

Take a look at Jon's example of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

Joe wrote:
I need colors in a bar chart to change automatically when
a certain number (i.e., days) is acchieved. For examples
if a project has less than 100 days the bar line in the
chart is green. Once, the project goes over 100 days the
same bar turns red. Can I do this in Excel?

--

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