Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default My charts are copied into Word in black and white instead of colou

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



  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: My charts are copied into Word in black and white instead of colou

Hi Feroni,

It sounds like a frustrating issue, but I'm here to help you resolve it. Based on the information you provided, it seems like the issue is related to your user account settings. Here are some steps you can take to try and fix the problem:
  1. Open Excel and go to File Options Advanced.
  2. Scroll down to the Display section and make sure the "Disable hardware graphics acceleration" option is checked.
  3. Click OK to save the changes and close Excel.
  4. Open Word and try pasting the chart again to see if it appears in color.

If that doesn't work, you can try the following steps:
  1. Open Excel and go to File Options Trust Center Trust Center Settings.
  2. Go to the Protected View tab and uncheck all the options.
  3. Click OK to save the changes and close Excel.
  4. Open Word and try pasting the chart again to see if it appears in color.

If neither of these solutions work, you can try resetting the Excel settings to their default values:
  1. Close all Office applications.
  2. Press the Windows key + R to open the Run dialog box.
  3. Type "excel.exe /reset" (without quotes) and press Enter.
  4. Open Excel and try copying the chart again.

I hope one of these solutions works for you.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default My charts are copied into Word in black and white instead of colou

Each user account stores its own preferences - in the account generating
B&W, open the XL file, go to FilePage Setup - Sheet, & remove the check for
'Print in Black & White' (I believe the wording is the same in '02, I'm
using '03).
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"Feroni" wrote in message
...
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





  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default My charts are copied into Word in black and white instead of c

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

"CyberTaz" wrote:

Each user account stores its own preferences - in the account generating
B&W, open the XL file, go to FilePage Setup - Sheet, & remove the check for
'Print in Black & White' (I believe the wording is the same in '02, I'm
using '03).
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"Feroni" wrote in message
...
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula Sum If With Duplicate JR573PUTT Excel Discussion (Misc queries) 18 February 21st 06 09:41 PM
Why is my printer printing white fonts as black? Howie Excel Worksheet Functions 2 November 24th 05 09:33 PM
convert a graph to black and white Help with Thesis Charts and Charting in Excel 1 May 26th 05 07:25 PM
Excel Object copied to Word not printing in color dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:40 PM
Convert diagram bars to black and white Detfunkar Charts and Charting in Excel 1 January 15th 05 09:23 AM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"