Open your spreadsheet Select your dataset for which you want to create a candlestick chart Go to Insert->Chart Google Sheets will automatically insert a Candlestick chart for your selected data