HomeGoogleGoogle SheetsAnalyze Data with Trend Lines in Charts

13.18. Analyze Data with Trend Lines in 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.



18 STEPS

1. The first step is to open a Google Sheet and create a chart (to learn how to create this chart, go here: https://helpdesk.plcschools.org/index.php?pg=kb.page&id=389.) Now, click on your chart.

Step 1 image

2. Click Options

Step 2 image

3. Click Edit chart

Step 3 image

4. Click Customize

Step 4 image

5. Click Series

Step 5 image

6. Scroll down and click trendline

Step 6 image

7. My trend line is now in the chart, but I want to customize it. Click Line color.

Step 7 image

8. Click green

Step 8 image

9. I want my line to be thicker, so I will increase it's pixel size.

Step 9 image

10. Click 8px

Step 10 image

11. I also want it darker, so I will increase it's opacity to a higher percentage.

Step 11 image

12. Click 80%

Step 12 image

13. I also want to label my trend line. Click the drop down for "label".

Step 13 image

14. Click Custom

Step 14 image

15. Doubleclick Custom label

Step 15 image

16. Type Custom label and Press Enter

Step 16 image

17. Click Close

Step 17 image

18. That's it. You're done. I now have a trend line in my chart that is clearly formatted and labelled.

Step 18 image

Here's an interactive tutorial

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



Downloads

Knowledge Tags