We can create a Candlestick Stock chart in Excel using the inbuilt Stock chart option, Volume-High-Low-Close. Let us see the steps with an example. The table below contains a five-day stock volume traded and the price variation data. And suppose the requirement is to display the above data in a Candlestick Stock chart. Then here is how we can achieve the required graph using the inbuilt Stock chart in Excel. Step 1: Select the cell range A2:E7, click Insert à Stock, and pick the third Stock chart type. Once we click the required Stock chart type, we will get the Candlestick Stock chart as depicted below: Step 2: Right-click a closing value data point and select the Format Data Series option from the Format Menu to open the Format Data Series pane. Next, in the Fill & Line - Marker tab, set the desired Built-in type and then scroll down to change the marker color as per our requirement. Step 3: Finally, update the chart title. And click the chart area to enable the Chart Elements option (‘+’ icon) to update axis titles, and move the legend to the top. The final Candlestick Stock chart will be: Let us see the 24th July data to analyze the Stock chart. The blue bar represents the volume (primary Y-axis), 5100. The vertical line extends upwards to the high value and downwards to the low value (secondary Y-axis), $29.42 and $24, respectively. And the small horizontal line indicates the closing value, $26.59.