change color to black and white in excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created bar and pie charts (with color in excel). I need to change to b&w
to copy and paste into a word document (can't afford color printing 1000's of
reports). I found the print in b&w in excel, but that doesn't seem to help
me. I know I can go in and change the pattern for each data series, but all
have multiple data series and this seems clunky. Any suggestions of how to
transform a whole graph from color to black and white?
 
thanks John--I tried it and it definitely b/c b&w. But I have multiple
categories so need the crosshatches and different patterns. It seems that
Excel would have an automatic way of doing this, taking into account
different patterns for the number of categories in the data series?
 
Try grey scale else it's changing each one in turn i think
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top