Forum Discussion

Copper Contributor

Oct 03, 2018

Excel Graphs Change Size Depending on Screen Resolution(?)

I use Excel all day, every day...with a lot of graphs. Goal is to have graphs precisely sized -- either 6x6 or 6x9. I am using a new MS Surface Laptop running Windows 10 Pro with Excel via Office 365...

Charting

excel

tedmh

Copper Contributor

Aug 10, 2019

Phil Plourd

I have a similar issue and it's also driving me crazy. The issue is independent of the move and size with cells solution. The changes I'm seeing are small changes to chart sizes and seem related to changing screen resolution. I see very small changes to chart sizes just switching back and forth between normal view and page layout / print preview! For example, I set the chart size 2.0" x 2.85". the setting is to NOT resize/move with cells and I'm NOT moving the chart. I work for a while on the same computer and then notice the chart size has changed to 1.94 x 2.9 or something similar.

I am writing a VBA program that will set the charts back to the size I want, but that seems a bizarre thing to have to do.

Why can't Excel just keep the chart size I set?