Edit Chart Value Dialog Box, Formulas Tab (Report Designer)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Use the Formulas tab of the Edit Chart Value dialog box to define the values for the chart. The options on this tab vary depending on the type of chart.
Options
- Show formula as a new series
Select this option to show a formula that will be calculated based on the current series. If this option is not enabled, no other option relating to formulas is available.
- Mean
The Mean formula returns the average of data stored in a data series.
- Median
The Median formula returns the median for data stored in a data series.
- Bollinger Bands
The Bollinger Bands formula plots at standard deviation levels above and below a simple moving average.
- Moving Average
The Moving Average formula is an average of data calculated over a period of time.
- Exponential Moving Average
The Exponential Moving Average formula is an average of data calculated over a period of time where the most recent days have the more weight.
- Triangular Moving Average
The Triangular Moving Average formula is an average of data calculated over a period of time where the middle portion of the data has more weight.
- Weighted Moving Average
The Weighted Moving Average formula is the average of the data calculated over a period of time where the greater weights are attached to the most recent data.
- MACD
The MACD formula compares two moving averages of prices.
- Detrended Price Oscillator
The Detrended Price Oscillator formula is used to remove the trend from the price.
- Envelopes
The Envelopes formula is plotted above and below a moving average using a specified percentage.
- Performance
The Performance formula compares the current value with the first value.
- Relative Strength Index
The Relative Strength Index formula compares upward movements of the current value with downward movements, resulting in a value which ranges between 0 and 100.
- Standard Deviation
The Standard Deviation formula measures the difference between values and the average.
- TRIX
The TRIX formula is based on triple moving average. It keeps the current value in trends that are shorter than the specified period.
- Show formula in a new chart area
Select this option to show the formula that you have specified in a new chart area. If this option is not specified, the formula will be shown in the same chart area as the original series.
- Show formula in legend
Select this option to show the formula in the default legend.
See Also
Reference
Other Resources
Working with Chart Data Regions
How to: Add Data to a Chart (Report Designer)