If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trendline for multiple series
Hello- How can you add a single trend line to approximate
the trend shown by multiple series of data over same time frame? |
#2
|
|||
|
|||
trendline for multiple series
Bill -
You can combine all the values into a single column of X and one of Y. Then either calculate the fitted formula in the worksheet (look up LINEST in the on line help), or add this meta series to your chart, using no lines or markers, and use it for the trendline in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Bill wrote: Hello- How can you add a single trend line to approximate the trend shown by multiple series of data over same time frame? |
Thread Tools | |
Display Modes | |
|
|