Creating an Efficient Dashboard in Excel

Posted on
8,806 Points
41 Endorsements
Last Modified:
Experience Level: Beginner
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.

Rather than update each graph to point to a different set within a static set of data, try creating a dynamic set that will update for you!  This video will show you how.
1 Comment

Expert Comment

Because of the size of the spreadsheet in the video, I was unable to see what was being entered, both data and formulas.

Is there a way to make the spreadsheet in the video full screen?

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month