Question: I dont know why im wrong, how do I use the category label on the chart? Please help me and I will rate you later,


I dont know why im wrong, how do I use the category label on the chart? Please help me and I will rate you later, thanks!
4/8 5. Gudrun would like a pie chart representing the percentage of the parks' budget that would go to each park in 2021. a. Create a 2-D Pie chart based on the data in the range E5:E9 and using the category labels in the range A5:A9. b. Resize and reposition the chart so that the upper-left corner is located within cell G21 and the lower-right corner is located within cell 039, and then left-align the chart with the pie chart above it in the range G2:020. X Insert a chart. The Spending worksheet should contain a pie chart using labels based on the values in the range A5:A9. Resize and reposition a chart. E5 I X fx A B E G H K L M N O R S T U V C D Alanis Parks Department Spending on Parks, 2018-2021 Om + 2018 Park Spending as Percentage of Total Trend $172,331 , 12% Park 5 Carver $ 6 Fern-Foley $ 7 Oleander S 8 Pleistocene $ 9 Sartoris $ 10 Total $ 11 12 2018 172,331 $ 225,280 $ 302,212 $ 200,098 $ 552,636 $ 1,452,557 $ 2019 178,606 $ 241,898 $ 302,805 $ 207,832 $ 569,846 $ 1,500,988 $ 2020 180,624 247,033 310,247 221,167 575,239 1,534,311 2021 189,794 252,853 319,880 237,810 586,124 $552,636, 38% $225,280, 15% 1,586,460 Spending per Park 2018-2021 12 Sartoris $302,212,21% Select Data Source $200,098, 14% Pleistocene Chart data range: =Spending!$E$5:$E$9 2021 Park Spending as Percentage of Total Oleander a Switch 12% 11 Fern-Foley 37% 2 16% Legend Entries (Series) Add Edit X Remove 3 4 24 25 23 26 20 27 21 28 20 29 29 30 JU 31 31 32 34 33 so 34 35 39 36 30 37 38 38 39 39 40 40 41 42 43 Carver Series 1 20% 15% -$200,000 $300,000 $1,800,000 $2,300,000 $800,000 $1,300,000 2018 2019 2020 2021 0 Graded Summary Report Documentation Spending Projection Bond Offering + Hidden and Empty CellsStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
