Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change color to black and white in excel 2003 | Charts and Charting in Excel | |||
color page display black and white | Excel Worksheet Functions | |||
Color Excel Spreasheet print previews in black/white. Reason? | Excel Worksheet Functions | |||
How can I change dafault color in excel from black to another? | Excel Worksheet Functions | |||
How do I change all chart colors to black and white? | Charts and Charting in Excel |