I have an Excel spreadsheeet that produces charts. Those charts are then pasted as links into a Word document, meaning that when the charts are modified in the spreadsheet, they automatically update in the Word document as well. The charts have gradated shading, going from light at the bottom to dark at the top. This all works fine.
The next step is that I save the Word document to PDF. No matter how I do this, the shading gets messed up -- roughly speaking it gets reversed, so that the light is at the top and the dark at the bottom, but it's actually worse than that because just reversing the shading in Excel doesn't fix it: although it then ends up the right way up, the shading just looks wrong -- there's a thin strip of light about 2/3 of the way down each bar, which fades out up and down the bar.
Anyone have any idea what might cause this and what I can do about it? I've tried every Word-to-pdf converter I can find, including the Microsoft one, and they all do the same thing.
I'm using Ofice 2007. I've also tried it with MS Publisher 2007, which also does the same thing.
Thanks!
Ben
