Thread: Chart daily data and add a trend line for each week
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
  
Posts: 461
Default Chart daily data and add a trend line for each week
Slope is m and Intercept is b. For desired values of X, calculate Y
using the well known formula

Y = mX + b

With X and Y in adjacent columns, plot each segment as a new series in
the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/12/2010 8:44 AM, clcnewtoaccess wrote:
I have the Slope& Intercept calculations, How do I calculate the X& Y
values from this?
Reply With QuoteReply With Quote