Forum Discussion

Phil Plourd's avatar
Phil Plourd
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
nabilmourad's avatar
nabilmourad
MVP
Aug 10, 2019

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

Resources