Excel graphics changes size while moving to another file

manekankit

Board Regular
Joined
Feb 1, 2019
Messages
72
Office Version
  1. 365
Platform
  1. Windows
I have prepared a dashboard in excel which contains two sheets. 1. Data and 2. Dashboard.
Dashboard sheet contains graphics wherein I have used formula to derive values from cell in Data sheet.

Now i want to copy both both these sheets to another file.

While copying to another file, all the graphics (which contain values derived by formula) change size automatically and become larger in width
I tried setting the property to move but don't resize, don't move and don't resize but nothing seems to be working.

Requesting help to resolve the issue.

I am using office 365 for desktop on win10.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
PS: noted that under Graphic Size and properties> Graphic Size - Values for scale height and scale width in new file automatically changes for the graphic to 92% and 98% while copying sheet to another file.
 
Upvote 0

Forum statistics

Threads
1,224,747
Messages
6,180,710
Members
452,994
Latest member
Janick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top