change color to black and white in excel 2003
 

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?

change color to black and white in excel 2003
 

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?

"John" wrote:

Select the chart. Hold shift & click on edit select Paste picture. on the
picture toolbar the second icon from the left will alow you to change it to
black & white or grey scale. then copy it into word
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"SDK" wrote:

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?

change color to black and white in excel 2003
 

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)


"SDK" wrote:

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?

"John" wrote:

Select the chart. Hold shift & click on edit select Paste picture. on the
picture toolbar the second icon from the left will alow you to change it to
black & white or grey scale. then copy it into word
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"SDK" wrote:

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?