Question about Excel sheet and Word '97

[Dirk_nl]

Hi,

When you create an Excel sheet, like graphs and give them several colors. And also make the background a transparant color (from white to yellow, for example) and you select the graph and copy it. Now when you paste this into Word, you can see the graph and the graph colors, but the background turned out to be in grey. When you double click this pasted sheet, you can see it's implemented via excel and the background color is visible. Only when printing it prints out in grey, while the graph-bars do have an color.

I think this is an Excel feature (making several different background for your graphics) and cannot be over-copied to MS Word, and therefore makes it black and white. Can someone confirm this? Or try it on their pc, and if there is a way to have this background be printed correctly via MS Word please let me know.

Thanks,


------------------
Kind Regards,

- Dirk -

[smurfy]

Hey there Dirk, is this the background of the chart plot area or the chart worksheet itself?

------------------
Sean (Smurfy)
....................
Please remember that others may need to know the outcome of your problem so please keep us updated.

[Dirk_nl]

Originally posted by smurfy:
Hey there Dirk, is this the background of the chart plot area or the chart worksheet itself?



It's the chart area. Right click Chart area for 'Format Chart Area' Click on Fill effects, choose a color and how it should appear. Now select this chart with it's background, do a copy (control+c) and do a paste in Ms word (control+v) it will appear in black and white... but if you double click the chart in MS word, it someone links to the Excel program and it now does show up in colors, but nevertheless it still prints out in black and white, while it appear is color on the screen (after you double clicked the chart in MS Word).

Did this answer your question? If you put in numbers in excel, to also display some graphs like vertical bars, those do appear in color (like red or whatever) and they also get printed correctly.



------------------
Kind Regards,

- Dirk -