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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding Trendline in XY Scatter graph
- Thread starter Bitaoo
- Start date
synapsevampire
Programmer
You've posted in a Seagate Info forum, try the Crystal Reports Other forum as this joint sees little action...
For version 8.5:
Open the Analyzer tab and select a riser (area, bar, line, marker, pie slice, etc.) or a legend marker.
On the Analyzer menu, point to Format Chart, then click Series.
-OR-
Right-click on the specified area and select Format Chart > Series from the shortcut menu.
-OR-
On the Analyzer Tools toolbar, click Series.
Select the Data Labels tab at the top of the Series Options dialog.
Options:
Show Trendlines: Select this check box to show or hide a trend line for the selected series.
Regression Type: Select one of these regression line types: Linear, Logarithmic, Polynomial, Exponential, or Moving Average to define the type of trend line you want to draw for the selected series. The moving average line is calculated from the data points for the selected series. This trendline smoothes the fluctuations in the data points and shows the pattern or trend.
-k kai@informeddatadecisions.com
For version 8.5:
Open the Analyzer tab and select a riser (area, bar, line, marker, pie slice, etc.) or a legend marker.
On the Analyzer menu, point to Format Chart, then click Series.
-OR-
Right-click on the specified area and select Format Chart > Series from the shortcut menu.
-OR-
On the Analyzer Tools toolbar, click Series.
Select the Data Labels tab at the top of the Series Options dialog.
Options:
Show Trendlines: Select this check box to show or hide a trend line for the selected series.
Regression Type: Select one of these regression line types: Linear, Logarithmic, Polynomial, Exponential, or Moving Average to define the type of trend line you want to draw for the selected series. The moving average line is calculated from the data points for the selected series. This trendline smoothes the fluctuations in the data points and shows the pattern or trend.
-k kai@informeddatadecisions.com
- Thread starter
- #3
Thanks for your complete answer and I am sorry that I sent this question to this forum by mistake.
This solution works for the other type of graphs except XY Scatter. Of course I am using Version 9, I don't know maybe this version has some bugs or doesn't support it any more for this type of graph. Because when I chose a series and select Format Chart > Series, Series Option ... window'll be opened and in this window Trendline tab is disable and I cannot enable it.
If you have any other idea or I am wrong, please let me know. Thanks.
--Bita
This solution works for the other type of graphs except XY Scatter. Of course I am using Version 9, I don't know maybe this version has some bugs or doesn't support it any more for this type of graph. Because when I chose a series and select Format Chart > Series, Series Option ... window'll be opened and in this window Trendline tab is disable and I cannot enable it.
If you have any other idea or I am wrong, please let me know. Thanks.
--Bita
synapsevampire
Programmer
That's the 8.5 solution, sorry it's the best I could come up with.
-k kai@informeddatadecisions.com
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question