May 17, 2007, 05:06 AM
<Shyam L>Regarding Scatter Graphs with Trend Lines
Hi All,
There is a requirement in whuch we need to generate a Scatter Graph with Trend lines. We know about the function setCurveFitType. But we want the Trend Lines to be based on a specific formula. Any ideas? Has someone used Excel macros for achieving the same?
Thanks in Advance,
Shyam
May 17, 2007, 05:07 AM
<Shyam L>we are using WF 7 version 1.6 on Windows platform.
May 17, 2007, 10:59 AM
susannahShyam, excel will curve fit for you, and plot the line. you can park your focus data into an excel template and create the graph in excel.
If you want to solve the trend line yourself, with a known or pre-determined formula, you could just define a new variable in your fex .