Remove design consulting data series excel

Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 Revenue Categories Lawn Maintenance April $7.886,48 July $7.650,23 August $7.683,30 September Total $46.715,63 Tree & Shrubbery $11.819,93 $11.909,48 $12.043,13 $11.803,28 $11.879,78 $12.226,28 $71.681,85 Patio and Furniture $15.192,23 $13.070,48 $12.957,30 $13.039,88 $15.318,23 $16.876,13 $86.454,23 Design Consulting $7.741,13 June $8.094,38 Fountains and Irrigation $7.660,13 May $4.478,18 $4.708,13 $4.475,25 $5.153,63 $5.514,53 $7.919,55 $32.249,25 $579,38 $585,23 $631,13 $563,18 $584,78 $698,40 $3.642,08 Total Revenue $39.729,83 $38.014,43 $37.993,28 $38.210,18 $40.980,60 $45.814,73 $240.743,03 Central Sierra Insurance Personal Lines Policy by Agent Policy Type Automobile Homeowners Recreational Vehicle Valuable Items AJP 155 230 28 12 RLN 201 318 54 2 EMM 165 265 31 5 Policy Type by Agent 350 300 250 200 150 100 50 0 AJP RLN Automobile Homeowners Recreational Vehicle EMM Valuable Items AJP Automobile Homeowners Recreational Vehicle Valuable Items USING MICROSOFT EXCEL 2016 Independent Project 3-4 Independent Project 3-4 For this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also build a pie chart sheet to graph the proportion that each category contributes to total revenue. Skills Covered in This Project Create a chart object. Size and position a chart object. Edit and format chart elements. Edit the source data for a chart. Download start file Build a pie chart sheet. Use texture as fill. Add and format data labels in a chart. 1. Open the ClassicGardens-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Create a Clustered Column chart object for cells A4:G9. 3. Move the chart object so that its top left corner is at cell A12. Size the bottom of the chart to reach cell H30. 4. Edit the chart title to display CGL Major Sales Revenue on one line, then press Enter and type Second and Third Quarters on the second line. 5. Apply chart Style 14 to the chart. 6. Format the first line and the second line of the chart title to a font size of 20 pt. 7. Apply a ½ point Black, Text 1 outline to the chart area. 8. Verify that the chart is still selected. In the highlighted range in the worksheet, drag the resize pointer to remove the Design Consulting data series from the chart (Figure 3-71). 3-71 Drag the resize pointer to change the chart data 9. Create a 3-D Pie chart for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Tools Design tab, Location group]. 10. Edit the chart title to display Revenue by Category. Change the font size to 32. 11. Select the legend and change the font size to 12. 12. Apply the Woven mat texture fill to the Patio and Furniture slice. Excel 2016 Chapter 3 Creating and Editing Charts Last Updated: 11/16/16 Page 1 USING MICROSOFT EXCEL 2016 Independent Project 3-4 13. Add data labels to display in the center of each slice. a. Display the Format Data Labels task pane, choose the Accounting format, and set 0 decimal places. b. While the data labels are selected, change the font size to 14 pt and apply bold [Home tab, Font group]. 14. Deselect the chart. 15. Save and close the workbook (Figure 3-72). Upload & Save Grade my Project 16. Upload and save your project file. 17. Submit project for grading. 3-72 Excel 3-4 completed chart sheets Excel 2016 Chapter 3 Creating and Editing Charts Last Updated: 11/16/16 Page 2 USING MICROSOFT EXCEL 2016 Improve It Project 3-7 Improve It Project 3-7 Central Sierra Insurance is a multi-office insurance company that handles commercial and personal insurance products. In this project, you add missing data and verify that the charts are updated. Skills Covered in This Project Edit source data. Switch row and column data. Change chart colors. Download start file Apply a chart style. Add and format elements in a chart. Change the chart type. 1. Open the CentralSierra-03.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Insert a new row at row 8. 3. Type Motorcycle in cell A8. In cells B8:D8, type these values: 15, 82, and 24. 4. Change the pie chart object to a 3-D Pie and apply Chart Style 3. Notice that a data series for "Motorcycle" has been added. 5. Switch the row and column data for the column chart. The data series for "Motorcycle" is not included. 6. Click the Select Data button [Chart Tools Design tab, Data group] and reset the source data to show cells A5:D10. 7. Change the column chart color scheme to Color 7 (gray) in the Monochromatic group.