Activity 8: Making a Line Chart
Activity 7: Making a Line Chart
Essential Learning Skills: creating a Line Chart, chart formats including labels, titles, legends, moving charts on the spreadsheet, creating a footer, and setting up Landscape format.
1. Open a new Spreadsheet file.
2. Billy is 14 years old and he is interested in becoming a good bowler. In fact, his goal is to be one of the best bowlers in the BMS Student Bowling League. Let’s take a look at his average scores for the last six months to see how he is doing.
• Set up a spreadsheet file so that it contains the following information.
3. Line Chart
You use a line chart when you want to see how values have changed over a period of time. A line chart makes it easy to identify a trend, if one exists.
• Select cells A1 through B6
• Click the Chart Wizard button form the Standard Toolbar.
• Choose Line and select the sub-type you desire.
• In step 3, click the Title tab and type Billy’s Bowing Average as the chart title. Then click the Legend tab and remove the check in front of “Show Legend.”
• Your chart should look something like this . . . . .
• You may change the format of your chart to make the background lighter, make the lines
darker, etc. The
easiest way is to
right click in the
chart and format the
chart area, the plot
area, and the data
series.
4. Finishing
• In the footer, type Activity 7, 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 7.
• Only when instructed to print, print in landscape format.
• Submit through Edmodo or as directed by your teacher.
................
................
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
- plotting in excel
- how to make a line graph with multiple lines
- statistics for everyone
- a beginner s guide to simrad chartplotters
- activity 9 comparing data in a line chart
- step by step 1 select data to include in a chart
- sample hiring process step chart
- activity 8 making a line chart
- how to make an excel line graph ms brannagan s page
Related searches
- making a line graph worksheet
- blank line chart template
- excel line chart examples
- create line chart in excel
- plotly line chart by group
- plotly line chart python
- excel line chart example
- 4 8 practice b line of best fit
- cumulative line chart excel
- plot line chart matplotlib
- plot line chart python
- line chart in python