I would have thought that one of the diagram autostyles, whilst not black
and white, will render ok for the purpose.

Autoformat on the diagram toolbar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Detfunkar" wrote in message
...
How can I in an easy way convert an excel diagram to be black & white. I
have
made a lot of diagrams and realised very late that i will only be able to
print them in black and white. Does anyone know of functionality that lets
me
change from the colored diagram, to bars that are easily recognizeble in
b&W?