Focal Point
Regarding Scatter Graphs with Trend Lines

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3091063822

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
susannah
Shyam, 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 .




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID