Point to the bottom right selection handle to display the resize arrow.Drag the chart object so its top-left corner is at cell A21.Point to the chart object border to display the move pointer.Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13.Change the project file name if directed to do so by your instructor, and save it. The file will be renamed automatically to include your name. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. Open the BlueLakeSports-03 start file.If the instruction does not match your version of Office, try using the alternate instruction instead. This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps.
You also create a line chart to illustrate week-to-week sales for specific departments in one of the stores and insert sparklines in the data.įile Needed: BlueLakeSports-03.xlsx (Available from the Start File link.)Ĭompleted Project File Name: -BlueLakeSports-03.xlsx Skills Covered in This Project For this project, you create a pie chart that shows each store’s share of golf-related sales for the first quarter. Blue Lake Sports has locations in several major cities and tracks sales by department in each store.
