“How can I find the formula for a graph on excel?”


“How can I find the formula for a graph on excel”

— Anonymous question

  1. Select the data points, insert and scatter. (For this to work, it has to be a scatter graph )
  2. Click on the chart and navigate to the tab chart design. Click add chart element, trendline and select the type of graph you have.
  3. Right click on the trendline and format trendline. Make sure you’re on the trendline options tab of the menu that pops up (it has an icon of bars).
  4. Click the checkbox saying “display equation on chart”.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Discover more from Understanding STEM

Subscribe now to keep reading and get access to the full archive.

Continue reading