Solved

Excel chart printing problem

Posted on 2012-03-28
6
214 Views
Last Modified: 2012-06-06
We've been having the strangest issue lately and it seems to be affecting all employees in the company (about 20 users). For about the past 3 months some of the text on our Excel charts will not print. The weird thing is that everything is displayed on the screen in print preview. For example, let's say I have a chart that has data labels on the bars, a legend, and a text box with some descriptions. I'll hit print preview and all the text is displayed. When the physical sheet is printed the text is not there. I've changed the color fill on the text boxes and legends and that does not fix it. I've also saved the document in the old 2000-2003 format (I'm using Excel 2007), and that didn't resolve the problem either. There's no print area set. We've copied the charts to a new sheet and that didn't resolve it. This is just one example, everyone in the company is having this kind of trouble, and, upon research using Google, it seems to be an issue with other users as well.

I've attached screenshots to help troubleshoot the problem. Any suggestions will be welcome as everyone is calling me to fix their charts every month and it's wearing me out.
physicalprinted.pdf
printpreviewscreentshot.JPG
0
Comment
Question by:jbarnette
  • 3
  • 2
6 Comments
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37776519
It is probably your printer driver.  You should look to see if the printer manufacture has a more current printer driver for your OS.  The other thing you can check is if your systems are fully updated. I would run Windows Update to ensure that both windows and Office are fully up to date.
0
 

Author Comment

by:jbarnette
ID: 37776527
It happens on any printer we try and used to work 3 months ago. I've tried it on 3 different Dell printers and 2 HPs and it does the same thing on all of them. It even happens when printing to PDF.
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37776538
Then  the common factor is the systems.  Please check from a system that is fully updated.  Are all the users using the same OS?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:jbarnette
ID: 37776774
All are using Windows 7 Pro and Office 2007 Pro with all updates installed for both. Nothing new has been installed that would have caused this problem to all of a sudden appear, unless there was a Microsoft office update that messed everything up. I've read in other forums that could be a cause...a bad MS update...but if that's the case then MS needs should have fixed the problem by now. Any other suggestions?
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 37777056
There was indeed a recent update that caused this - see this PAQ: http:/Q_27544422.html

I have read that setting the chart area fill to None can also help.
0
 

Author Closing Comment

by:jbarnette
ID: 38053502
Uninstalling the microsoft office update fixed it. Thank you.
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question