| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Trendlines"
| Line 1: | Line 1: | ||
From [[version 7.5]] it is possible to add trendlines to [[Small Multiple Charts]], these can either be added to an individual series by right-clicking on it and selecting "Add Trendline" or the entire chart by right-click that. | From [[version 7.5]] it is possible to add trendlines to [[Small Multiple Charts]], these can either be added to an individual series by right-clicking on it and selecting "Add Trendline" or the entire chart by right-click that. | ||
| − | [[Image: | + | [[Image:smctrendline1.png|thumb|center|250px]] |
| + | |||
=Options= | =Options= | ||
| + | |||
| + | [[Image:smctrendline.png|thumb|center|250px]] | ||
== Series == | == Series == | ||
| Line 23: | Line 26: | ||
== Exponential == | == Exponential == | ||
| + | [[Image:exptrendline.png|thumb|center|250px]] | ||
| + | |||
== Linear == | == Linear == | ||
| + | [[Image:lineartrendline.png|thumb|center|250px]] | ||
| + | |||
==Logarithmic== | ==Logarithmic== | ||
| − | == | + | [[Image:logtrendline.png|thumb|center|250px]] |
| + | |||
| + | ==Polynomial== | ||
| + | [[Image:polytrendline.png|thumb|center|250px]] | ||
| + | |||
==Power== | ==Power== | ||
| + | [[Image:pwrtrendline.png|thumb|center|250px]] | ||
| + | |||
==Moving Average== | ==Moving Average== | ||
| + | [[Image:avgtrendline.png|thumb|center|250px]] | ||
=Editing and Removing= | =Editing and Removing= | ||
Right-click on the trendline legend to edit or delete it | Right-click on the trendline legend to edit or delete it | ||
Revision as of 11:27, 24 June 2013
From version 7.5 it is possible to add trendlines to Small Multiple Charts, these can either be added to an individual series by right-clicking on it and selecting "Add Trendline" or the entire chart by right-click that.
Contents
[hide]Options
Series
Select the series for the trendline
Title
Provide a title for the trendline to be displayed on the legend
Colour
Select a colour of the trendling
Trendline Type
There are various options for calculating the trendling, select the appropriate option.
Exponential
Linear
Logarithmic
Polynomial
Power
Moving Average
Editing and Removing
Right-click on the trendline legend to edit or delete it
