Word 2003: embbeded excel charts partially not printing in colour

[rmassart]

Hi there,

I am generating word documents using Visual Basic. These word documents contain embedded excel bar charts which are populated with user provided data. The default color of the bars in the template that is processesd is orange and have no pattern applied. Depending on the values being populated these bars are then either coloured green or red and also have a pattern applied (either stripes or checked).

The idea of the pattern is to be able to distinguish between red and green when printing in black and white. What is happening now is that when printing (in colour) the colours on the green or red bars are not printed, ie they are printed in grey. But the pattern is being printed. If I remove the pattern, then the colours do print.

Note: previewing the print in Word works fine and the colours do display. I am quite happy to post some code or even provide access to the word document, but in the first instance if someone has any ideas why Word does not print the embedded charts ad they are displayed in the print preview, that would be great.

Many thanks for any help,
Robin

 

[macropod]

Hi Robin,

Are you able to convert the Word documents to PDF? If the colours come through correctly there, then it's likely to be an issue with the print driver - and you may also then be able to print the documents correctly from the pdfs.

Cheers

[MS MVP - Word]