How do I add a curve of best fit?

K

Kat

I want to add a curve of best to a set an x-y scatterplot. The data points
are roughly logarithmic. The only thing i can seem to do is add a line of
best fit a moving average line or polynomial line. How do i just get a nice
best fit curve that shows the trend of data points?
 
J

Jon Peltier

Kat -

Try using Add Trendline from the Chart menu. There is a set of fitted
curve options, including linear, logarithmic, polynomial, power,
exponential, and moving average. If you have negative numbers in your
data, you may not be allowed to select logarithmic, power, or
exponential fits, depending on where the negative values occur.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top