Forum Discussion

Ajay_Varma's avatar
Ajay_Varma
Copper Contributor
May 02, 2022

Excel dashboards automatically resize for different screen sizes

Hi there,

Recently i have created Dash Board for easy understanding of stats to a customer. I did this in my laptop (screen Size 1366*768) with 70% zoom fit and shared the same file over mail. It is completely different when i saw the same in customer desktop (resolution 1920*1200). All my work (tables, Slicers, Graphs) looks small and i need to zoom in to 100% to fit the dash board in their screen and i still used scroll bar to move in and out during my presentation. Felt really awkward and discomfort while presenting in front of all during annual review meeting.

 

Googled on this topic and failed to find potential solution to my problem. 

 

Last hope, i am putting this question to Excel developers in this forum who can help me. 

 

I heard, VBA codes will help to autofit the dash board size based on the screen sizes. If any thing like that available, please share the information.

 

Appreciate your help in advance. 

 

Thanks,

AJ

No RepliesBe the first to reply