Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I add functions together in an excel Chart?
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? |
#2
|
|||
|
|||
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/ _______ Brian wrote: 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? |
#3
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel | |||
Excel should have an open/close high/low chart for stock market u. | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |