how do I add functions together in an excel Chart?

G

Guest

I am trying to determine the equation for three different functions in a
scatter plot on graph in excel. I then want to have excel add these
functions together.

Does anyone know how to perform these functions?
 
J

Jon Peltier

You can use the trendline feature to determine the formula. Select a
series, then use Add Trendline from the Chart menu.

To add these functions together, you can add together coefficients of
the individual trendlines. To avoid errors, display the trendline
formulas with a high degree of precision: format the formula, and on the
Number tab, choose a Scientific format with 15 decimal digits.

- 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

Similar Threads

Bubble Chart best fit Scatter plot 3
How to create a bubble chart with more than 2 variables 0
trendline in scatter plot 3
How do I put multiple lines on a scatter chart? 1
Y axis fixed value problem 1
Adding a linear equation to my groovy scatter plot. 10
Excel 2007 Scatter Plot Freak Out! 3
How do I disable automatic chart creation in Excel? 1

Top