Productivity Suite

Q4 Party Planner: Charts

13. Dig the Data


What if you want to see a simple visual of your party plans? The easiest way to visualize something quickly is to make a chart. This Quest will show you how simple it is to make a chart.

Key Vocabulary

Chart: Charts are visual representations of worksheet data. Charts often make it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Select: The action where you use the mouse (or alternate) to click on a particular cell, image, or object on the screen


Making a Chart

1. What data will you choose to chart?
To create a chart we have to first decide what to include. Let's start by including the headings #Invited and #Attending and the numbers (our data). Looking at our chart, we want to select cell B2 and all the data below (but not the totals), and C2 and all the data below that. In our example we will select B2 all the way to the last cell of data in column C which is C7 (shown in the white area).

There are a couple of ways to select all these cells. 1. Click in B2 and holding your mouse, drag down to C7 and let up. 2. You can also click in B2, hold down the shift key, then click in cell C7 (you decide which works best)

2. Create the Chart
Select the chart icon charticonon the tool bar if it is showing, or click on the More button to show it (you can also use the INSERT Menu and then CHART from that menu). 


You will see your data in several different chart examples that are "recommended" by Google. Take a moment to look at each one and decide which one shows the comparison of numbers invited to attending that makes the most sense to you. Discuss the differences with others or as a class.

Choose the type of chart that you feel will display the information the best and click on it.

Click on the Insert button.

Make it smaller on your page by clicking and dragging in on one of the corners of the chart diagram. You can also move it next to, or underneath your data table.

To delete it, click on it to select it and hit your backspace or delete key. Then try a different type of chart following the same steps.

3. Name the Chart

Select your chart by clicking once on it, and then click on the dropdown arrowQ4customizechart

to CUSTOMIZE it and select Advanced Edit (you are now in the Customization section). Type a name for your chart in the Title box (Party Planning). Then change the size of the font for the Legend to eight. Click on the Update button when done. 

4. Check with your teacher to see if you should turn it in yet on continue to the last part of Party Planning.

Additional Resources

Microsoft Excel

 Check off this Quest on the 21t4s roadmap 

Ready for Quest 5  Sharing Your Spreadsheet

ISTE and Common Core Standards

ISTE Standards•S

3. Knowledge Constructor
c. curate information from digital resources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions

5. Computational Thinker
b. collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision making. 

6. Creative Communicator
c. communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models or simulations