Thread: Axes of Published Chart Blacked Out

Hello all - I have encountered an interesting problem this morning with Excel 2003. I have a VBScript that opens Excel and executes a macro. The macro pulls some data in and a chart is updated. The chart is then re-published as an MHT file.

When I execute this macro as an interactive user of Excel, the chart is published properly; however, whenever the macro is executed by the VBScript, the published chart's axes, axes titles, and title are all blacked out (even though the body of the chart is published properly).

I haven't had much luck searching for a similar issue - has anyone else seen this behavior before? Any suggestions would be greatly appreciated.

Thanks!

Doug

Here is a screen shot of an exported chart (with axes blacked out). If I execute the same code from within Excel (i.e.: not automated through VBScript), the chart publishes properly.

Screen Shot

...also tried exporting it as a GIF with the same results. I am really baffled.

I have tried to force a refresh of the chart itself in the code, but this has not solved the problem either.

Seems like if I explicity set the background and font colors (as opposed to Automatic), the problem is resolved.