You can create links between cells and images or shapes. Doing so gives you control over how the information appears in your dashboard and allows you to move data on a dashboard freely.
- [Instructor] Creating links between cells…is a great way to summarize data.…What's more, you can also create a link…between a cell and a shape.…Doing so gives you control over how the information…appears in your Dashboard…and allows you to move data on the Dashboard…without having to update the formulas…that appear in the worksheet cells.…In this movie, I will demonstrate how to link…a cell value to a shape.…My sample file is the Link to Shape workbook,…which you can find in the chapter two folder…of your exercise files collection.…
I have a very basic Dashboard setup.…I'm really just getting started.…And what it shows is room service revenue,…guest count and department expenses for a hotel chain.…Let's say that I want to display average daily room rate,…which is a very important measure across a hotel chain.…Let's also say that it's important enough…that I don't want to confine it to a single cell.…I want to be able to move that value around.…That means I need to put the value in a shape.…So first I will create the shape.…
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