Excel has four different types of stock charts.
It is important to remember that you must organize your data in the correct order to create this and other stock charts. In other words, if you opt to create a High-Low-Close chart then your data needs to be ordered High Price, Low Price, Closing Price.
Creating Stock Charts
It is important to remember that you must have the correct number of series that the chart requires. Excel also requires that the data be in the proper order.
1. Select your data
2. Click Insert and Select Other Charts icon
3. Select the type of stock chart you wish to create