Ron, I believe the trendline feature uses the Trend() function, so maybe you can do it on the worksheet instead of deriving from the chart. See the group of Statistics functions/jason -----Original Message----- From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On Behalf Of Ron Nossaman Sent: Sunday, May 14, 2006 11:25 AM To: Pianotech Subject: Excel trendline Brain pool - help! Excel has a trendline feature in it's charting system, to visually smooth the data. Does anyone know a way to get the set of smoothed data point values BACK from the second degree polynomial trendline routine, or how to use the trendline's Y and R^2 formulas to reconstruct the smoothed set in a column? Yes, it's piano related. Thanks, Ron N
This PTG archive page provided courtesy of Moy Piano Service, LLC