<

Creating an Efficient Dashboard in Excel

Posted on
8,834 Points
1,734 Views
41 Endorsements
Last Modified:
Experience Level: Beginner
9:31
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.
41
1 Comment

Expert Comment

by:MEGlobal
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?
0

Featured Post

Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This is for people with spreadsheet skill, but not necessarily yet book-keeping skills, which with this “starter template” will give you the lists headings and a few fairly simple calculations you need to get going. 

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month