Home

Excel Graphs Change Size Depending on Screen Resolution(?)

%3CLINGO-SUB%20id%3D%22lingo-sub-266037%22%20slang%3D%22en-US%22%3EExcel%20Graphs%20Change%20Size%20Depending%20on%20Screen%20Resolution(%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266037%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20Excel%20all%20day%2C%20every%20day...with%20a%20lot%20of%20graphs.%20Goal%20is%20to%20have%20graphs%20precisely%20sized%20--%20either%206x6%20or%206x9.%20I%20am%20using%20a%20new%20MS%20Surface%20Laptop%20running%20Windows%2010%20Pro%20with%20Excel%20via%20Office%20365.%20I%20have%20three%20different%20%22set%20ups%22%20for%20my%20computer.%20Two%20utilize%20two%20large%20displays.%20The%20third%20is%20just%20using%20my%20laptop.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20issue%3A%20the%20graphs%20change%20size%20depending%20on%20the%20setup%20I%20am%20using.%20A%20graph%20that%20was%20saved%20in%20a%20spreadsheet%20at%206x6%20while%20sitting%20at%20my%20two-screen%20setup%20in%20my%20office%20is%205.7x6.38%20when%20I%20open%20it%20on%20my%20laptop%20directly%20or%20on%20my%20two-screen%20setup%20at%20home.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20prevent%20this%3F%20Driving%20me%20crazy%20and%20and%20I%20cannot%20seem%20to%20google%20my%20way%20to%20resolution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EPhil%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-266037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266046%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Graphs%20Change%20Size%20Depending%20on%20Screen%20Resolution(%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20might%20be%20wrong%20but%20I%20though%20you%20just%20set%20the%20following%20and%20it%20would%20fix%20it%20in%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20297px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55338iFA337386011E1C89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20capture.JPG%22%20title%3D%22Excel%20capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798297%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Graphs%20Change%20Size%20Depending%20on%20Screen%20Resolution(%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F221733%22%20target%3D%22_blank%22%3E%40Phil%20Plourd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20issue%20and%20it's%20also%20driving%20me%20crazy.%20The%20issue%20is%20independent%20of%20the%20move%20and%20size%20with%20cells%20solution.%26nbsp%3B%20The%20changes%20I'm%20seeing%20are%20small%20changes%20to%20chart%20sizes%20and%20seem%20related%20to%20changing%20screen%20resolution.%20I%20see%20very%20small%20changes%20to%20chart%20sizes%20just%20switching%20back%20and%20forth%20between%20normal%20view%20and%20page%20layout%20%2F%20print%20preview!%26nbsp%3B%20For%20example%2C%20I%20set%20the%20chart%20size%202.0%22%20x%202.85%22.%26nbsp%3B%20the%20setting%20is%20to%20NOT%20resize%2Fmove%20with%20cells%20and%20I'm%20NOT%20moving%20the%20chart.%20I%20work%20for%20a%20while%20on%20the%20same%20computer%20and%20then%20notice%20the%20chart%20size%20has%20changed%20to%201.94%20x%202.9%20or%20something%20similar.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20writing%20a%20VBA%20program%20that%20will%20set%20the%20charts%20back%20to%20the%20size%20I%20want%2C%20but%20that%20seems%20a%20bizarre%20thing%20to%20have%20to%20do.%3C%2FP%3E%3CP%3EWhy%20can't%20Excel%20just%20keep%20the%20chart%20size%20I%20set%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798463%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Graphs%20Change%20Size%20Depending%20on%20Screen%20Resolution(%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F221733%22%20target%3D%22_blank%22%3E%40Phil%20Plourd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Phil%3C%2FP%3E%3CP%3EAs%20a%20good%20practice%20when%20creating%20Charts%2C%20is%20to%20make%20sure%20whenever%20you%20change%20the%20Column%20Width%20or%20the%20Row%20Height%26gt%3B%26gt%3B%20your%20Chart%20size%20doesn't%20change.%20To%20do%20that%20either%20Right%20Click%20and%20select%20Format%20Chart%20at%20the%20bottom%20of%20the%20Menu%20or%20(much%20easier)%20use%20the%20%3CSTRONG%3Eshortcut%20CTRL%20%2B%201%3C%2FSTRONG%3Eto%20open%20it%20on%20the%20Fly%26gt%3B%26gt%3B%20in%20the%20rightmost%20Tab%20%26gt%3B%26gt%3B%20expand%20Properties%20%26gt%3B%26gt%3B%20and%20select%20the%20radio%20button%20for%20%3CSTRONG%3EDon't%20move%20or%20Size%20with%3C%2FSTRONG%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%3A%3C%2FP%3E%3CP%3EUse%20the%20same%20option%20with%20the%20same%20shortcut%20CTRL%20%2B%201%20for%20%3CSTRONG%3Eany%20Floating%20object%3C%2FSTRONG%3E(Chart%2C%20Picture%2C%20Shape%2C%20even%20a%20SLICER).%20A%20nice%20tip%20here%2C%20there%20is%20a%20special%20toggle%20shortcut%20to%20Hide%2FReveal%20any%20floating%20object%20in%20your%20sheet%2C%20that%20is%20%3CSTRONG%3ECTRL%20%2B%206%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThis%20is%20a%20key%20point%20when%20preparing%20your%20Charts%20and%20Slicers%20for%20using%20them%20in%20a%20Dashboard%3C%2FP%3E%3CP%3EI%20explained%20that%20in%20many%20of%20my%20tutorials%20on%20creating%20Dashboards%3C%2FP%3E%3CP%3EHere%20is%20a%20sample%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_GCT8n__pO8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_GCT8n__pO8%3C%2FA%3E%3C%2FP%3E%3CP%3Eand%20another%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DQa2z9YWH5JM%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DQa2z9YWH5JM%3C%2FA%3E%3C%2FP%3E%3CP%3EBest%20of%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Phil Plourd
Occasional Visitor

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. I have three different "set ups" for my computer. Two utilize two large displays. The third is just using my laptop.

 

Here's the issue: the graphs change size depending on the setup I am using. A graph that was saved in a spreadsheet at 6x6 while sitting at my two-screen setup in my office is 5.7x6.38 when I open it on my laptop directly or on my two-screen setup at home.

 

Is there anyway to prevent this? Driving me crazy and and I cannot seem to google my way to resolution.

 

Thanks,
Phil

 

3 Replies

I might be wrong but I though you just set the following and it would fix it in place.

 

Excel capture.JPG

@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?

@Phil Plourd 

Hi Phil

As a good practice when creating Charts, is to make sure whenever you change the Column Width or the Row Height>> your Chart size doesn't change. To do that either Right Click and select Format Chart at the bottom of the Menu or (much easier) use the shortcut CTRL + 1 to open it on the Fly>> in the rightmost Tab >> expand Properties >> and select the radio button for Don't move or Size with ...

 

By the way:

Use the same option with the same shortcut CTRL + 1 for any Floating object (Chart, Picture, Shape, even a SLICER). A nice tip here, there is a special toggle shortcut to Hide/Reveal any floating object in your sheet, that is CTRL + 6

This is a key point when preparing your Charts and Slicers for using them in a Dashboard

I explained that in many of my tutorials on creating Dashboards

Here is a sample:

https://www.youtube.com/watch?v=_GCT8n__pO8

and another

https://www.youtube.com/watch?v=Qa2z9YWH5JM

Best of Luck

Nabil Mourad

This is your one stop shop for learning everything about Charts in Excel. But, with the many charts we create you'll learn an amazing functionality in which I show All the charts -whatever their number- in ONE single window, and switch between the charts by selecting a different option from a drop
In this tutorial I create multiple charts from a source table and then create a Drop Down List that allows me to switch between the different charts and the Source table. This amazing technique can be used in creating a dynamic Dashboard. You can download the start file and follow along by ...