Google Sheets of Pie and Column Charts

Google Sheets of Pie and Column Charts

In this lesson, you will learn how to build a Pie and & Column Chart.

You have been working at a coffee shop for the past eight months. Each week, your manager gives the employee with the highest sales a $25 gift card. You offer to visually illustrate weekly sales by creating a pie and column chart. To motivate the staff, these will be posted on the employee bulletin board.

1. Open Google Sheets.
2. Title the document Pie and Column Charts.
3. Enter the data in Google Sheets as shown below.
4. Highlight cells A1 & B1 then click the Merge and Center Command
5. Highlight cells A3 & B3 then click the Center Align Command
6. Bold cells A3 & B3
7. Change the font size of cells A1 & B1 to 14
8. Change the background color of cells A1 & B1 to light green 1 by clicking the Fill Color Command
9. Format column B as currency.

New Skill – Create a Pie Chart:

10. Click on cell A3, then click on Insert, and click on Chart
11. On the right of the screen, the Chart Editor will appear
12. Under Chart type, click on Pie Chart
13. At the top of the Chart Editor, Click on the Customize Command.
14. Click on the Chart Style Command.
15. Change the background color to, light gray 1.
16. Click on the Pie Chart Command.
17. Go to the Slice Label Command, Click the drop-down arrow, and select Value. Each pie slide will have a value inside of the slice.
18. Click on the Chart & Axis Titles Command, go to the Title Text. Type in “Sales Week of December 27”. This will change the title of the chart to the title you typed.
19. Make the Title Format, Bold and the Font Color, dark cornflower blue 3.
20. Click on the Legend Command. Go to the drop-down arrow under Position Command select right. This will format the Legend on the right of the Pie Chart.

New Skill – Move a Chart to another Sheet:

21. Click in your Pie Chart. At the top right you will see three dots. Click on the dots. This will open a menu, click on the Command Move to Own Sheet. The Pie Chart is now on its own sheet.
22. Look at the bottom of your Google Sheets, you will see two sheet tabs. Sheet 1 and Chart 1.

New Skill – Change Sheet Name:

23. Go to the bottom of Google Sheet, right-click on Sheet 1. A menu will appear.
24. Click on Rename, type Sales by Day.
25. At the bottom of Google Sheet, right-click on Chart 1. A menu will appear.
26. Click on Rename, type Sales by Day Pie.

New Skill – Create a Column Chart:

27. Click on the Sales by Day sheet.
28. Select cell A3, then from the Insert Menu, click on Chart.
29. On the right of the screen, Chart Editor will appear.
30. Under Chart Type, click Column Chart.
31. At the top of the Chart Editor, Click on Customize Command.
32. Click on Chart & Axis Titles Command.
33. Go to the Title Text and change the title to Sales by Day.
34. Put this completed assignment in the Gsuite Folder.

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!