Q4 Party Planner: Charts
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.
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 on 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 arrow
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.
- YouTube Video on using Charts
- Google Spreadsheets Google Docs Help Inserting a Chart in a Spreadsheet
- Spreadsheet Help from Google
- Using Google Spreadsheets from About.com
- Tutorial on "Working with Charts"
Check off this Quest on the 21t4s roadmap
Ready for Quest 5 Sharing Your Spreadsheet
ISTE and Common Core Standards
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