Knowledge Books

Home → Google → Google Sheets → Analyze Data Over Time with Timeline Charts

13.20. Analyze Data Over Time with Timeline 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.


9 STEPS

1. Timeline charts can be a great way to visualize data over time. The first step is to open your desired Google Sheet, then click Insert

Step 1 image

2. Click Chart

Step 2 image

3. Click Chart Type: Column chart

Step 3 image

4. Scroll down and click Timeline Chart.

Step 4 image

5. Click Select data range

Step 5 image

6. Type Range. In this case, we will use A1 - B17, which contains our Dates and Average Scores on Assignments for Students on those dates.

Step 6 image

7. Click OK

Step 7 image

8. We can now visualize our averages for students over time, clearly showing a severe drop in performance halfway through November. To zoom in along th timeline, I can Click and drag the slider at bottom.

Step 8 image

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

Step 9 image

Here's an interactive tutorial

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


Downloads

Knowledge Tags
timeline  /  charts  /  Google Sheets  /  data  /  analzye  / 

← Analyze Data with Radar Charts Share a Chart or Graph in Google Sheets →