Creating a Candlestick Stock chart
![Candlestick chart in Excel for Microsoft 365 Candlestick chart in Excel 365](/images/tips/254_365/1.png)
To create a Candlestick chart in Excel for Microsoft 365, do the following:
1. Depending on the type of stock chart you want to create, you must include a specific combination of data series in your worksheet - and put the data series in order:
- High-Low-Close:
- High price
- Low price
- Closing price
- Open-High-Low-Close:
- Opening price
- High price
- Low price
- Closing price
- Volume-High-Low-Close:
- Volume traded
- High price
- Low price
- Closing price
- Volume-Open-High-Low-Close:
- Volume traded
- Opening price
- High price
- Low price
- Closing price
2. Select the data range (in this example, A2:E22, the data from Yahoo Finance):
![Candlestick chart data Excel for Microsoft 365 Candlestick chart data Excel 365](/images/tips/254_365/2.png)
3. On the Insert tab, in the Charts group, choose the Insert Waterfall, Funnel, Stock, Surface, or Radar Chart button:
![Insert Waterfall, Funnel, Stock, Surface, or Radar Chart in Excel 365 Insert Waterfall, Funnel, Stock, Surface, or Radar Chart in Excel 365](/images/tips/charts365/waterfall_radar.png)
In the Insert Waterfall, Funnel, Stock, Surface, or Radar Chart dropdown list, in the Stock group, choose Open-High-Low-Close:
![Open-High-Low-Close stock chart type in Excel for Microsoft 365 Open-High-Low-Close stock chart type in Excel 365](/images/tips/charts365/ohlc.png)
Excel creates a stock chart:
![Candlestick draft chart in Excel for Microsoft 365 Candlestick draft chart in Excel 365](/images/tips/254_365/3.png)
4. Do one of the following:
- On the Chart Design tab, in the Data group, choose Select Data:
- Right-click in the chart area and choose Select Data... in the popup menu:
In the Select Data Source dialog box, make sure that all your data series are added correctly in the Open-High-Low-Close order:
![Select Data Source in Excel for Microsoft 365 Select Data Source in Excel 365](/images/tips/254_365/4.png)
5. Right-click on the category axis, then select Format Axis... in the popup menu (or double-click the axis):
![Format Axis popup in Excel for Microsoft 365 Format Axis popup in Excel 365](/images/tips/charts365/format_axis.png)
6. On the Format Axis pane, on the Axis Options tab:
- In the Axis Type group, select the Text axis option:
- In the Number group, choose Custom in the Category field and then change the field Format Code (for example, to show only days) and click the Add button:
You can then make any other adjustments to get the look you desire.
See also this tip in French: Comment créer un graphique chandelier japonais ou un graphique boursier.