paste excel chart into word changes bar color shading

[brain thesis]

I have created several charts in Excel which I am trying to paste (or
otherwise put) into a Word document. When I copy / paste special, the
style of shading I have assigned to the different types of bars in
Excel appears differently in the Work document

Specificall, I have chosen, in Excel, to color a bar, I have chosen
Fill Effects > Pattern > diagonal striping (bottom row, 3rd from left)
for one type of data

When this Excel chart is pasted into Work, this shading becomes a solid
dark grey, not the diagonal striping I want. I have try all
combinations I can see in Paste Special - ie. paste vs paste link, and
As Excel Chart Object vs As Picture.

Suggestions greatly appreciated.

Thank you.

 

[JE McGimpsey]

I have created several charts in Excel which I am trying to paste (or
otherwise put) into a Word document. When I copy / paste special, the
style of shading I have assigned to the different types of bars in
Excel appears differently in the Work document

Specificall, I have chosen, in Excel, to color a bar, I have chosen
Fill Effects > Pattern > diagonal striping (bottom row, 3rd from left)
for one type of data

When this Excel chart is pasted into Work, this shading becomes a solid
dark grey, not the diagonal striping I want. I have try all
combinations I can see in Paste Special - ie. paste vs paste link, and
As Excel Chart Object vs As Picture.

Yup, it's a bug with the way the patterns are copied to the clipboard.

Which is why pasting as a picture doesn't work - the picture on the
clipboard is bad.

One workaround is to copy it as a picture in XL (hold down the shift
key, and choose Edit/Copy Picture). You can then paste it into Word
normally.

 

[CyberTaz]

I believe most patterns will also transfer accurately if you use
Insert>Object>From File, as that also bypasses the clipboard... Just make
sure that the XL file is open with the Chart Sheet in front or save & close
it that way.

Regards |:>)

 

[brain thesis]

Thanks very much - that worked liked a charm! A life saver.

(answer also in ...word group)