1 / 3

Add Trendline

Add Trendline. Right click on data points. Modify your graph: Select your graph and copy then paste it so you have 2 identical graphs.

zenda
Télécharger la présentation

Add Trendline

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Add Trendline • Right click on data points

  2. Modify your graph: Select your graph and copy then paste it so you have 2 identical graphs. Modify the formula bar to select different years. The top graph is 1881 to 2011 and the bottom graph is 1950 to 2011 (in this example 1950 data starts in row 228) By interchanging the Ps with Rs you can switch x and y axes. =SERIES(,Sheet1!$P$228:$P$289,Sheet1!$R$228:$R$289,1)

  3. Modify your graph: Select your graph and copy then paste it so you have 2 identical graphs. Modify the formula bar to select different years. The top graph is 1881 to 2011 JJA temps vs DJF temps, and the bottom graph is 1881 to 2011 JJA temps vs year. =SERIES(,Sheet1!$A$159:$A$289,Sheet1!$R$159:$R$289,1)

More Related