MrExcel Publishing
Your One Stop for Excel Tips & Solutions

regression analysis trendline


Posted by John Adair, M.D. on January 19, 2002 2:47 PM

in a scater gram graph I have a 14 data point and want to add a regression analysis trendline. The help file says there is an "add trendline" type tab on the chart menu. I have looked and looked and cannot locate it. I know its there as I accidently got it once but cant seem to do it again.


Posted by Bariloche on January 19, 2002 5:18 PM

John,

Right click on your data line or a data point. The context menu that pops up should have the item "Add trendline ..." on it.

enjoy