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.…
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: Link cell contents to a shape