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.Insert and format sparklines in a worksheet.Create, size, and position a pie chart object.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.
Finish this excel project please it will the instruction in the word docīlue Lake Sports has locations in several major cities and tracks sales by department in each store.
