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…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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