Stock chart
A stock chart is a niche chart in Excel and is mostly useful for displaying the price movement summary of financial market securities. It requires a strict table structure and may not be easy to read for those not accustomed to it.
Stock charts accept a four-table structure:
- High-Low-Close
- Open-High-Low-Close
- Volume-High-Low-Close
- Volume-Open-High-Low-Close
Figure 8.32 shows a stock chart with the Open-High-Low-Close table structure. The bars can be set to different colors:
Figure 8.32 – Stock chart for the Open-High-Low-Close data series
We will move now to the next chart.
