Stock Charts
A stock chart is specifically designed for financial or scientific data that uses up to four values per data point. These values align with the high, low, open, and close values that are used to plot financial stock data. This chart type displays opening and closing values by using markers, which are typically lines or triangles. In the following example, the opening values are shown by the markers on the left, and the closing values are shown by the markers on the right:
.gif "Stock chart")
Variations
- Candlestick. The candlestick chart is a specialized form of the stock chart, wherein boxes are used to show the range between the open and close values. Like the stock chart, the candlestick chart can display up to four values per data point.
Data Considerations for Stock Charts
When presenting many stock data points, such as annual stock price trend, it is difficult to distinguish each open, close, high and low value of each data point. In this scenario, consider using a line chart instead of a stock chart.
When axis labels are generated, labeling usually begins at zero. In general, stock prices do not fluctuate to the same degree as other data sets. For this reason, you might want to disable the axis labels from starting at zero to get a better view of your data. To do this, set IncludeZero to false in the Axis Properties dialog box or the Properties window. For more information about how the chart generates axis labels, see Formatting Axis Labels on a Chart.
Reporting Services provides many calculated formulas for use with stock charts, including Price Indicator, Relative Strength Index, MACD and more.
See Also
Reference
Calculated Series Properties Dialog Box, General
Axis Properties Dialog Box, Axis Options