You might want to make certain information easily available even if it’s not shown. You can do so by hiding worksheet rows that contain some of the details displayed in the dashboard.
- [Instructor] Dashboards summarize a lot of data…in a compact format.…You should avoid the temptation to display…too many items on a dashboard,…but there will be times when you want…to make certain information easily available,…even if it's not shown all the time.…You can do that by hiding worksheet rows…that contain some of the details displayed in the dashboard…by creating custom groups.…I'll show you how to group and ungroup rows in this movie.…My sample file is HiddenRows,…and you can find it in the chapter two folder…of the exercise files collection.…
The top portion of this dashboard worksheet…contains information such as room service revenue,…guest count, department expenses, and then a pivot chart…indicating quarterly expenses by department.…Starting in row 11, you can see that I have…Target Quarterly Expenses by Department in 2017,…and then I have the targets in rows 12 through 15…for each of my four departments.…The thing is I don't really need to see the targets,…but I'm assuming that the manager who's using this dashboard…
Released
3/8/2017- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows
Share this video
Embed this video
Video: Extend your dashboard using hidden rows