From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Update graphs

Update graphs

- [Instructor] We had an outstanding fundraising costume party, and we kept a tally of the donations, who donated, and we put their costumes in a category. Jo Ann showed up just like a guitar. Therefore, she's in the category, Inanimate Object, and she donated 60 bucks, and here are two graphs. The number of costumes and then we have the amount of donations by costume type. And we have two pivot tables here on the Details tab. So let's go back to Sheet3. Where's your help needed? This new data needs to be needed wherever it needs to go, so that it's included in the graphs. So that's part of your mission is to find that source data, and then refresh to update the graphs, and finally, let's look over here, where it says Total in the graph on the right, change that to Donations by Costume. Got that? All right, pause the video. Grab that exercise file, add the new data, come back, and we'll do it together. All right, you're back. Okay, we've got to do some sleuthing to find out where the…

Contents