Solved

Distortion printing gradient shapes in Excel

Posted on 2014-01-14
2
681 Views
Last Modified: 2014-01-15
I have created a Gantt chart in Excel using shapes with a gradient fill.  It looks great in excel, but when i print it distorts around the shapes.  

Please see the attached screen shot of the excel doc and a pdf of the print out.

Is there a setting or a better way to print this without the distortion?

If I remove the gradient from the shapes, it will print without distortion.
Capture.PNG
Print.pdf
0
Comment
Question by:mgmee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 500 total points
ID: 39781603
You probably used Auto size to fit the data on the print. This cant be solved without changing your sheet.
Try to make all columns a little smaller and print at 100%
0
 

Author Closing Comment

by:mgmee
ID: 39782183
That works.  Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
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 will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

689 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