Forum Discussion
Issue with Excel graph shrinking when printing
Hi Kimber,
I know exactly what you are talking about. I was googling this issue and found your message. There isn't much out here speaking to this.
I have charts on separate worksheets and it is random when they will shrink to fit on a 8.5 x 11 paper when printing. You cannot change the chart size when it is on its own worksheet. But I do want it to fit on 8.5 x 11 paper when printing.
Did you have any luck on fixing the issue. I noticed nobody responded to your post.
Thanks!
No, I never found anyone else that has the issue nor did I find a fix other than deleting the messed up ones and copying new ones to the same position - which is how they got there in the first place! I also have never figured out a pattern for the issue.
Note that I do not have 'fit to page' selected for scaling. Instead I formatted everything to fit perfectly on an 8.5 x 11 page. You should be able to change the chart size if it is on its own worksheet though. When you go to print, do not have the chart selected. I notice if you have a chart selected (even on my sheet with multiple charts), only that one will show up in the print preview AND the page is not formatted correctly. For example, I have my sheets set up as landscape. If I select one chart and then look at print preview, it shows just the one chart and the page is portrait. See my attached screen capture.
