1 "What is the top-grossing Disney animated film franchise?" 455A WNT 2 3 In this worksheet, you will create a PivotTable, then use the information from that PivotTable to create a Column Chart. 6 A film franchise is a group of related films (e.g., same characters). Some of the top-grossing animated films are related. For instance, Lion King has two versions and some have sequels. You are going to do some analysis of this. Follow the steps below. 7 1. In the indicated area to the right, create a PivotTable that shows the sum of Worldwide Gross (in billions) for each franchise. - You will need to add a column in the Top-Grossing Animated Films worksheet with the name of the overarching franchise (For example, use "Nemo-Dory" for that franchise). 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 - You will need to add another column to convert the Worldwide Gross into billions. Label this new column "Worldwide Gross ($b)" - In the blank cells for your new column, divide the Worldwide Gross values by 1,000,000