Candlestick Chart in Excel

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.

Leave a Comment