Microsoft Office Tutorials and References
In Depth Information
T ABLE 2-12 STOCK CHART SUBTYPES (Continued)
Displays the stock’s volume and high, low, and closing
prices. Requires four data series.
Displays the stock’s volume and open, high, low, and
closing prices. Requires five data series.
Figure 2-23 shows an example of each of the four stock chart types. The two
charts on the bottom display the trade volume and use two value axes. The daily
volume, represented by columns, uses the axis on the left. The “up-bars,”
sometimes referred to as candlesticks, depict the difference between the opening and
closing price. A black up-bar indicates that the closing price was lower than the
A stock market chart can display any number of data points. Figure 2-24, for
example, shows three years of data for a company. This chart plots all five
variables: volume, open, high, low, and close. With this many data points, individual
days are not discernible, but trends are easy to identify.
Figure 2-23: Four stock charts