My charts are copied into Word in black and white instead of colou

[Feroni]

I often create colour charts in Excel, which I copy into a Word document to
be used as part of a report. I now have a problem that when I paste these
charts into my report, they are in black and white instead of colour. Can
anyone help me to resolve this problem.

I copy a chart by selecting the chart, then I use either Edit/copy or the
Ctrl-C command to copy it. To paste the chart into my report, I use either
Edit/paste or I right-click with the mouse and select paste from the context
menu.

To try to identify the cause of this problem, I started the clipbook viewer.
I can see my chart is in black and white. I then tried copying from other
applications such as Powerpoint, IE, Hypersnap and I also tried Alt-Print of
the Excel window. All of these copied in colour. So my problem appears to be
restricted to Excel.

This problem started when I switched from using my old Username/Domain to a
new account which is Username/Local computer. I did not change computers, I
only changed User accounts. If I logon with my old user account, I can copy
Excel charts to Word in colour.

I checked all the options for Excel, they are the same for both user
accounts. I even re-installed Office XP, but the same problem still exists.

I'm running Excel 2002 (10.6789.6735) SP3 on Windows XP SP2.

Thanks in advance for your help. Feroni

 

[CyberTaz]

Each user account stores its own preferences - in the account generating
B&W, open the XL file, go to File>Page Setup - Sheet, & remove the check for
'Print in Black & White' (I believe the wording is the same in '02, I'm
using '03).

 

[Feroni]

Hi Bob, Thanks for your suggestion. I didn't have 'Print in Black and White'
ticked. But your suggestion did get me thinking. I tried some more
experiments and I found that this problem only applied to a couple of
workbooks. The charts in all my other workbooks happily copy in colour, but a
couple of workbooks will only copy in B&W. Then I worked out a circumvention.
If I changed my default printer to my colour printer instead of my B&W
printer, then even my recalcitrant charts copied in colour. I checked the
good and the bad workbooks, but I couldn't find any parameter that was
different in either File/Page Setup or Tools/Options.

Thanks. Feroni