ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Printing causing a scale change (https://www.excelbanter.com/charts-charting-excel/100190-printing-causing-scale-change.html)

F*SH

Printing causing a scale change
 

Hi again

I've got all my graphs looking beautiful - on screen. But when I print
or preview, the axis labels are reformatted for some reason. Because I
need all my graphs to maintain their axis positions when printed, this
is a problem.

For example, I have a variable that varies between 12 and 18. The scale
in Excel works well: 10 to 20. Ideal, really. But printouts, without any
obvious provocation, change this scale to perhaps 9.5 to 19.5 - very
annoying. Any ideas why it does this and more importantly how to stop
it?

Cheers!


--
F*SH
------------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...o&userid=36355
View this thread: http://www.excelforum.com/showthread...hreadid=562888


F*SH

Printing causing a scale change
 

Hmm, further experimentation suggests this problem is being caused by
the scaling done by the print pre-processor. It seems that, in an
effort to squeeze the chart so the sheet will fit onto a printout 1
page wide, the charts' texts is being reformatted. Is there a way to
overrule this reformatting while scaling?


--
F*SH
------------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...o&userid=36355
View this thread: http://www.excelforum.com/showthread...hreadid=562888



All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com