Activity 3: Getting Fancy with Column Charts
Activity 2: Getting Fancy with Column Charts
Essential Learning Skills: comparing data, setting up a column chart, changing chart formats including labels, gridlines, titles, colors, and legends.
1. Open a new spreadsheet file.
2. Mrs. Jones recently polled all the students attending Baker Middle School. One of the questions she asked was, “What is your favorite cafeteria lunch?” The choices students could select from included hot dogs, burgers, tacos, pizza, or spaghetti. There were some interesting differences when the results were examined by gender.
Favorite Lunch Boys Girls
Burgers 60 40
Hot Dogs 70 20
Pizza 60 60
Spaghetti 20 60
Tacos 35 5
Create a spreadsheet file that includes this information. You should have data in cells A1 to C6.
3. Select the contents of cells A1 through C6 for inclusion in a column chart. Use the Chart Wizard, and follow the instructions from Activity #2 if necessary.
4. Chart Customization
• After the column chart is created, edit it by first clicking once in the white space inside the chart. Then go to Chart. Choose Chart Options.
• Click the Titles tab. Add labels for the x- and y-axis if you did not create them initially.
• Click the Gridlines tab. Get rid of the check in front of Value (Y) Axis, Major Gridlines.
• Click the Legend tab. Change the placement of the legend to Bottom.
• Click the Data Labels tab. Click Values. Click Next - Finish.
• Click on one of the columns that represent data from boys. This should put a little box in each of the boy columns.
➢ Right-click on one of the columns. Choose Format Data Series. In the window that appears, choose a color that you would like to use to represent the boys’ data. Then click the Fill Effects button. Experiment with the Gridlines, Textures, and Patterns tabs until you are satisfied with the outcome.
➢ Make similar changes to the girls’ bars.
➢ Your chart should look something like this.
5. Click cell B5 and change the number to 40. Watch the chart as you press Enter.
6. Finishing:
• In the footer, type Activity 2. Press Enter, and type your name.
• Don’t forget to print preview to double check that your chart is just the way you want it.
• Go to File and select Save. Name the file SS Act 2.
• Submit through Edmodo or as directed by your teacher.
-----------------------
[pic]
If you followed the gridlines tab directions, these lines should NOT show in the background of your chart.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
Related searches
- getting started with minecraft
- getting started with minecraft pi
- getting started with mutual funds
- getting honest with yourself
- getting started with amazon fba
- not getting along with coworker
- getting started with youtube
- 3 column charts fillable
- getting along with co workers
- getting together with friends quotes
- not getting along with coworkers
- column charts templates