HomeGoogleGoogle SheetsAnalyze Data With Line Charts

13.17. Analyze Data With Line Charts

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-it interactive" to select your preferred viewing method. Then, click start.


13 STEPS

1. The first step is to open Google Drive, then select the Google Sheet you want to use a Line Chart in. In this case, we will use John's Vocab Progress - Google Sheets to create a graph based on a student's progress on vocabulary words.

Step 1 image

2. With your mouse, click and drag to highlight the cells upon which you want to base your chart.

Step 2 image

2b. Drop

Step 2b image

3. Click Insert

Step 3 image

4. Click Chart h

Step 4 image

5. Google Sheets has automatically guessed that I wanted a Line Chart. If it hadn't, I can always go to Chart Type: at right and click the drop down to select my desired chart type.

Step 5 image

6. My Line Chart looks good, but I want John's progress to also include the dates on the horizontal axix. To do so, Click Add X-axis

Step 6 image

7. Click Select a data range

Step 7 image

8. Click Range and type the cells which contain the dates.

Step 8 image

9. Click OK

Step 9 image

10. Click Close

Step 10 image

11. I now have my line chart, correctly labelled, and can click and drag it around as needed.

Step 11 image

12. Click highlight

Step 12 image

13. That's it. You're done.

Step 13 image

Here's an interactive tutorial

https://www.iorad.com/player/1739631/Docs-Google---How-to-untitled-task-name



Downloads

Knowledge Tags