Link cell contents to a shape

- [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.…