Skip to content
View in the app

A better way to browse. Learn more.

Tip.It Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Excel trend line help

Featured Replies

Hello, I hope you can help me on this.

 

As you can see from the image below I have 2 graphs, now what I need to do and need you help on is, I need to somehow get the line of best fit from the right graph onto the left.

 

My teacher said that if I simply add the equation for the line from the right and add it in to the data for the left graph it should appear although I have been unable to replicate this.

I have been unable to do so but I have had a look on the internet, tried to do what she said, copy the line over, add the equation into another trend line but I still cannot find out a way of doing this.

 

Its just frustrating and thought you lot might be able to help and so I wont have to wait and ask again tomorrow.

 

Thanks.

 

 

19718811.png

Please click below to help with my ICT A Level, for which I have to monitor my website for 8 weeks, hits and feedback welcome.

 

http://www.chauncystweb.co.uk/sm

 

Feedback page now up and working.

Alright, try putting the two graphs next to eachother on same spraedsheet. Then, click on the trendline you need moved. Hit Ctrl+C and then go over, click on the graph you need both lines on, and hit Ctrl+P.

 

This should get you 2 sets of data on the one graph, then simply click the data you just added to the graph, and add a trendline. You should be able to adjust the options for color and stuff like normal.

pere_grin.png

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.