Creating a Candlestick Stock chart

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

   2.   Select the data range (in this example, A2:E22, the data from Yahoo Finance):

   3.   On the Insert tab, in the Charts group, choose the Insert Waterfall, Funnel, Stock, Surface, or Radar Chart button:

In the Insert Waterfall, Funnel, Stock, Surface, or Radar Chart dropdown list, in the Stock group, choose Open-High-Low-Close:

Excel creates a stock chart:

   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:

   5.   Right-click on the category axis, then select Format Axis... in the popup menu (or double-click the axis):

   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.