Here it is in action ( view in your web browser). The macro allows you to easily create different “views” for different screen sizes, and then automatically apply those views when the user opens the file or resizes the workbook window. I wrote this set of macros to help solve this problem. So how do we accommodate for all the various sizes? The Responsive Excel Dashboard Macros It won't be long before we are looking at Excel dashboards on our watch and our Hololens. Modern devices come in just about every screen size you can imagine. It also allows the user to see relationships between the data on the different charts without having to scroll horizontally or vertically. This prevents your dashboard from getting too cluttered. Most good dashboard design books and courses will tell you that it is best to fit all the elements of your dashboard on one page/screen. He wants to make sure that the user can see all the elements of his dashboard on one screen, without having to scroll horizontally or vertically. This could be anything from a small laptop to a large monitor. Ryan has an Excel file that contains a dashboard, and he sends this file to a bunch of different vendors (users).Įach user is opening the file on a device with a different screen size. This was an issue for my friend Ryan (LinkedIn). Bottom line: Learn how to make your Excel dashboards automatically resize for different screen sizes with VBA macros.Īre Your Users Viewing Your Dashboards on Different Screen Sizes?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |