Print B&W in Excel 2007 vs. Excel 2003
 

In Excel 2003, if we set a page to print B&W, graphs and charts would still
print in color. It seems that in Excel 2007, if we set a page to print B&W,
the graphs and charts print in B&W, too. We often color code spreadsheets to
denote things that are linked and things that need to be updated, but when we
print it out, we don't want all the color coding to show, but we still want
the graphs and charts to be in color. Is there a way to get it to behave
like it did in Excel 2003?