A candlestick chart is a type of financial chart that displays the price movements of securities over time.
The following step-by-step example shows how to create a candlestick chart in Google Sheets.
Step 1: Enter the Data
First, let’s enter the prices for a dataset that show the low, open, close, and high price for a certain stock during an 8-day period:
Note: The Date column should be in Plain text format. If it is not, simply highlight the Date column, then click the Format tab, then click Number, then click Plain text.
Step 2: Create the Candlestick Chart
Next, highlight all of the values in the range A1:E9 as follows:
Then click the Insert tab and then click Chart:
By default, Google Sheets should create the following candlestick chart:
If Google Sheets creates a different type of chart for some reason, simply click the Chart type tab within the Chart editor and scroll down until you see the Candlestick chart option and click it.
Step 3: Modify the Candlestick Chart
Feel free to use the Customize tab within the Chart editor to modify the title of the chart and change the background color.
For example, we can change the title to ‘Daily Stock Price’ and modify the background color to be a light shade of grey:
Additional Resources
The following tutorials explain how to create other common charts in Google Sheets:
How to Create a Box Plot in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create a Pareto Chart in Google Sheets