Chart objects shift when printing

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I have created a multiple sheet Excel workbook, with
about 15 pages of charts and tables. The problem is that
when I print them (whether to a printer, or a print
preview), some of the objects move around.

For example, my value axis title, which appears as two
lines when viewing in Excel, appears as a single line in
Print Preview, and overlays across the plot area.

Another (more serious) problem occasionally occurs, when
the chart line (this is a line chart), moves itself up or
down when printing, so the data points displayed on the
chart do not match the data.

Has anyone had a similar experience? Any ideas of what
is causing it, or better yet, how to fix it would be
appreciated. I should also note that while I am opening
the file in Excel 2003, the file was originally created
in Excel 2000.

Thanks in advance!
-Glenn
 
Glenn -

I rarely have this problem. I think it's because I always move and
resize the various pieces of the chart. I think doing this removes any
urge for Excel to resize anything.

But I've also seen people blame outdated printer drivers for this
behavior. Point fingers at anyone else, right?

- Jon
 
See if either of these apply. If not, you might want to search the
MSKB for more information.

XL7: Chart Titles/Legend May Move When Zoomed Worksheet Opened
http://support.microsoft.com/default.aspx?scid=kb;en-us;142592

XL2000: Chart Is Reduced to a Small Size After Formatting the Legend
http://support.microsoft.com/default.aspx?scid=kb;en-us;211606

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
The 1st article actually helped with the axis titles and
legends shifting (curiously even thought it says the
problem was corrected way back with Excel 95).

I am still having the occastional problem with chart
lines shifting, which is a very serious problem, which I
have not been able to resolve. Nothing in the KB seems
relevant.

This almost always happens when I print to a PDF, but
sometimes in a print preview as well. I don't see
anything related in either MS or Adobe's support.
 
You might want to check if the problem is related to a view zoom
setting (View | Zoom...) Does the problem go away if you use 100% as
the setting?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top