Charts missing information on printout (look fine on screen)

AutoFilterQueen

Board Regular
Joined
Sep 28, 2011
Messages
90
I have a spreadsheet in Excel 2007 which crunches a large amount of data into 71 charts. The 71 charts are on a single worksheet, formatted to print four charts per page. Back on December 12, I was able to print the worksheet and everything appeared as I would expect. Now, I go back into the same file that has not been modified since December 12, and information is missing from the top two charts on each page of the printout. Everything looks fine on the screen and in print preview. In fact it is not only one worksheet that this has happened to, but several worksheets that were built from the same template. The top two charts on each page are missing the following:

- chart area border
- x axis labels
- y axis labels
- series names on legend
- data series markers
- data labels

I have tried several things while troubleshooting that I will share here. I will continue to try things but I would appreciate any insight anyone has on this problem. If I print the charts one to a page, everything prints fine. I tried several different printers and printed to Adobe PDF, all with the same result. I asked a coworker try printing this file to see if she would get the same results and she did. I tried moving the problematic charts from the first and second position on each page to the third and fourth position on each page, and they printed fine. I moved charts that were fine up to the top of each page, and they printed with missing information. I created new charts on the top half of each page, and they printed with missing information. I created new charts on the bottom half of each page, and they printed fine. My conclusion is that the problem appears to be tied to the rows or the cells as opposed to the charts. I am really puzzled by the fact that these printed fine on December 12 and the same files are not printing fine now.

Sorry for the long rambling post - I wanted to describe everything I have done so far. Any ideas on what is causing this or what I should try next? Thanks!
 

AutoFilterQueen

Board Regular
Joined
Sep 28, 2011
Messages
90
I believe the issue we're having is due to Microsoft Update KB2596596 which was issued on December 13, 2011. On Microsoft's website, the following notice is shown: "A regression of this update was reported in which graphs are not printed correctly or graphs may have parts missing when you print them. Microsoft is researching this problem and will post more information in this article when the information becomes available."

Here are a couple other forums where this problem is discussed:

http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/dec1c975-16b1-4b42-af44-a019740bc910

http://community.spiceworks.com/topic/187734-missing-excel-information-when-printing

I will try removing this update when I get to work tomorrow. If that doesn't help, I will post again here!
 

Forum statistics

Threads
1,082,026
Messages
5,362,738
Members
400,688
Latest member
ConnerR

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top