Gudrun has created a pie chart representing.. Change the data labels to include the Category as well as the Percentage, and position the labels in the Outside End location.
Gudrun has created a pie chart representing the percentage of the parks' budget that went to each park in 2018. Modify the chart in the range G2:O20 as follows:
a. Enter 2018 Park Spending as Percentage of Total as the chart title.
b. Change the data labels to include the Category as well as the Percentage, and position the labels in the Outside End location.
c. Remove the Legend from the chart.
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 O39, and then left-align the chart with the pie chart above it in the range G2:O20.
Customize the chart in the range G21:O39 as follows:
a. Enter 2021 Park Spending as Percentage of Total as the chart title.
b. Apply Style 3 to the chart.
a) Double click on the chart title and then paste the text. Paste in notepad and then paste there if you don't want to copy the styles too.
b) Double click in chart and new section will apear in right-hand-side. Click at chart options dropdown and select "Series 1 Data Labels". Click Series Options (last icon). Then click Label Options. Click the Category Name checkmark and select Outside End from Label Position.
c) Click on the Legent (box of the chart on right side). Right click and click delete option or hit delete key from keyboard.
a) Select range E5:E9 and the hit crtl or cmd key. Select A5. Click shift key and then select A9. This way you can select all cell ranges. Go to insert tab select 2D Pie from Charts group. b) Move your mouse in the corner of chart and expand/drag it to fit in the cell.
a) Double click in the chart title and enter 2021 Park Spending as Percentage of Total b) Click chart. Go to Chart Design tab. Select Style 3 from Chart Styles group.
b) Double click in chart and new section will apear in right-hand-side. Click at chart options dropdown and select "Series 1 Data Labels". Click Series Options (last icon). Then click Label Options. Click the Category Name checkmark and select Outside End from Label Position.
c) Click on the Legent (box of the chart on right side). Right click and click delete option or hit delete key from keyboard.
Video explanation: