Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

line of best fit or regression doable?

Status
Not open for further replies.

Iliemoo

Programmer
Sep 25, 2002
64
0
0
CA
Although my colleague doesn't think so, I am wondering if anyone knows if Crystal Reports can create line of best fit or some form regression when including graphs/charts? If so, how? Thanks!
 
For a regular line chart, select the chart, right click and go to the chart analyzer, select the line in the line chart, right click, and then select "curve fit and stat lines" for a broad selection of statistical lines.

For a stacked line chart, select the chart, right click and select chart analyzer, then select the line ->format chart->series->trendline.

There might be other variations depending on the type of chart you use that I'm not aware of, but it looks like CR can probably deliver what you want and this might get you started.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top