Excel 2007 - Some text in embedded charts does not appear upon print

[kettelfish]

I have a workbook built in Excel 2007 that has one sheet with a bunch of data and another with seven embedded pie charts summarizing the aforementioned data. The charts are arranged to print on three pages (3, 3, 1) and display beautifully both on-screen and in print preview. However, when they are printed, some of the chart titles, data labels, legend entries and text box text become invisible. I've tried printing on several different (all HP) printer models AND to Adobe (pdf), and the problem seems to be universal.


Symptoms of the problem: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

• The problem has only appeared recently; charts from this file printed fine around a month ago. <o></o>
• First chart on first or second page - all text is invisible. <o></o>
• The second chart on first or second page is missing the chart title, all but the first series' data labels and all but the last legend text. Text in a text box appears. <o></o>
• Third chart on page has everything. <o></o>
• Chart on its own page has everything. <o></o>
• The word "invisible" above is important in that in the pdf prints, the text is still there and selectable and can be copied and pasted, but just doesn't show. <o></o>
• Printing each chart individually using the Selected Chart radio button on the Print dialog solves the problem (but is not visually pleasing). <o></o>
• Printing the file after opening in Excel 2003 or 2010 appears to solve the problem (most of us don't have 2003 anymore and haven't upgraded to 2010). <o></o>
• Doing a "Save As..." to PDF and printing from the resulting file appears to solve the problem (most of us don't have the full version of Acrobat). <o></o>
• On printing to Adobe, changing the Page Setup Print quality option to less than the 600 dpi option appears to solve the problem (again, most of us don't have the full version of Acrobat). Increasing the quality causes more information to disappear. <o></o>

At this point, my assumption is that this problem is caused by some MS patch because it occurs regardless of printer but not in versions of Excel other than 2007. I've seen another file, created by a different person on a different computer that appears to have the same issue, so I'm concerned that this problem is soon going to balloon. I've searched around the internet and the MS Knowledgebase for similar problems and have come up with no viable solution.

Any feedback or solutions would be appreciated.

Thanks,

--Kettel

 

[lori.schlueter]

Ditto here, missing data labels on some graphs embedded on a sheet and I waited too long to hop on and find the answer here.

I spent all afternoon yesterday trying to trouble shoot the printer and print server.

Thanks for the no fill tip you saved the day, for my 7th grade advanced math students.