 |
| IXlsChartTrendLine |
|
COM interface ( getting help with interfaces )
interface IXlsChartTrendLine : IDispatch
{
[id(1),propget] HRESULT Show([out, retval]enumChartTrendLine* show);
[id(1),propput] HRESULT Show([in]enumChartTrendLine show);
[id(2),propget] HRESULT Options([out, retval]IXlsChartBorderStyle** options);
[id(3),propget] HRESULT PolynomialOrder([out, retval]int* polynomialorder);
[id(3),propput] HRESULT PolynomialOrder([in]int polynomialorder);
[id(4),propget] HRESULT LegendTitle([out, retval]BSTR* legendtitle);
[id(4),propput] HRESULT LegendTitle([in]BSTR legendtitle);
[id(5),propget] HRESULT ForwardForecast([out, retval]double* forecast);
[id(5),propput] HRESULT ForwardForecast([in]double forecast);
[id(6),propget] HRESULT BackwardForecast([out, retval]double* forecast);
[id(6),propput] HRESULT BackwardForecast([in]double forecast);
[id(7),propget] HRESULT InterceptValue([out, retval]double* interceptvalue);
[id(7),propput] HRESULT InterceptValue([in]double interceptvalue);
[id(8),propget] HRESULT DisplayEquation([out, retval]BOOL* displayequation);
[id(8),propput] HRESULT DisplayEquation([in]BOOL displayequation);
[id(9),propget] HRESULT DisplayRSquaredValue([out, retval]BOOL* displayrsquared);
[id(9),propput] HRESULT DisplayRSquaredValue([in]BOOL displayrsquared);
[id(10),propget] HRESULT CustomTitle([out, retval]IXlsChartTitle** title);
[id(11),propget] HRESULT Legend([out, retval]IXlsChartLegendEntry** legendentry);
[id(12),propget] HRESULT MovingAveragePeriods([out, retval]int* periods);
[id(12),propput] HRESULT MovingAveragePeriods([in]int periods);
}
HRESULT Show([out, retval]enumChartTrendLine* show);
returns how the trend line is displayed. Default is : not displayed.
HRESULT Show([in]enumChartTrendLine show);
sets how the trend line is displayed. Default is : not displayed.
HRESULT Options([out, retval]IXlsChartBorderStyle** options);
returns the options object.
HRESULT PolynomialOrder([out, retval]int* polynomialorder);
returns the polynomial order of the trend line. Valid for trendlines of type polynomial. Default is : 2. Valid values are within the range [1, 6].
HRESULT PolynomialOrder([in]int polynomialorder);
sets the polynomial order of the trend line. Valid for trendlines of type polynomial. Default is : 2. Valid values are within the range [1, 6].
HRESULT LegendTitle([out, retval]BSTR* legendtitle);
returns the custom title used to reference the trend line in the chart legend box. Default is : automatic text based on series name.
HRESULT LegendTitle([in]BSTR legendtitle);
sets the custom title used to reference the trend line in the chart legend box. Default is : automatic text based on series name.
HRESULT ForwardForecast([out, retval]double* forecast);
returns the forward forecast of the trendline. Default value is : 0.
HRESULT ForwardForecast([in]double forecast);
sets the forward forecast of the trendline. Default value is : 0.
HRESULT BackwardForecast([out, retval]double* forecast);
returns the backward forecast of the trendline. Default value is : 0.
HRESULT BackwardForecast([in]double forecast);
sets the backward forecast of the trendline. Default value is : 0.
HRESULT InterceptValue([out, retval]double* interceptvalue);
returns the intercept value of the trendline, where the trendline crosses axis Y. Default value is : no intercept value.
HRESULT InterceptValue([in]double interceptvalue);
sets the intercept value of the trendline, where the trendline crosses axis Y. Default value is : no intercept value.
HRESULT DisplayEquation([out, retval]BOOL* displayequation);
returns whether the equation of the trend line should be displayed. Default value is : no.
HRESULT DisplayEquation([in]BOOL displayequation);
sets whether the equation of the trend line should be displayed. Default value is : no.
HRESULT DisplayRSquaredValue([out, retval]BOOL* displayrsquared);
returns whether the root squared value of the trend line should be displayed. Default value is : no.
HRESULT DisplayRSquaredValue([in]BOOL displayrsquared);
sets whether the root squared value of the trend line should be displayed. Default value is : no.
HRESULT CustomTitle([out, retval]IXlsChartTitle** title);
returns the custom trend line title object. Default title is equation or root squared value.
HRESULT Legend([out, retval]IXlsChartLegendEntry** legendentry);
returns the legend object for this trendline.
HRESULT MovingAveragePeriods([out, retval]int* periods);
returns the moving average periods of the trend line. Valid for trendlines of type moving average. Default is : 2. It means the number of values making up the moving range.
HRESULT MovingAveragePeriods([in]int periods);
sets the moving average periods of the trend line. Valid for trendlines of type moving average. Default is : 2. It means the number of values making up the moving range.