If you’re not familiar with Excel, the Open-High-Low-Close style chart is actually a Candlestick Chart. Here’s how to make one.
1. Select the range of data that includes the headers and fields for Open-High-Low-Close
2. Open the Chart Wizard (click the chart icon on your toolbar)
3. Select the “Stock” chart Type
4. Click the Open-High-Low-Close Sub-Type
5. You can click Finish to view your chart, or change the look and feel of your candlestick chart by going through the rest of the wizard.