From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Add a shape

Add a shape - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Add a shape

“

- This is pretty neat. We want to insert a shape, and then have that shape show the total revenue. And it's got to be variable. Check this out. I'm going to change this to 1,000. Our shape updates. But also, prevent the shape from moving around, because this gets annoying. Watch, I'm going to double-click. No, I want the shape to stay in one place. Alright, pause the video. Pull up the exercise file. Work it out. Come back, and we'll go through it. Alright, you're back. Let's do this thang. Okay, we're going to go to Insert. Insert a shape. Whatever shape we want. Let's go back to this one. Alright, now we need a sum of the revenue. I'm going to put that here. Equals, sum, open parenthesis, this Revenue column, Enter. To connect our shape to that value, we have to select a shape. Go to the formula bar. Equals, and then select a value. Enter. It's beautiful. Slide it over a bit. Okay, so I'm…

Contents