Creating an Efficient Dashboard in Excel

Posted on
8,990 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


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?
Excel formula name translator: Spanish - English and English - Spanish and work in both languages  
For decades, the Visio org chart wizard has generated diagrams from data automatically. But all subsequent changes were manual and required recreating the diagram. The Visio Data Visualizer changes the game -- you can either change the data or the d…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month