Author: Oscar Cronquist Article last updated on September 26, 2018

The candlestick chart allows you to plot price movements of stocks, derivates, bonds and currencies.

A black candlestick in Excel tells you that the closing price is below the opening price and a white candlestick indicates that the closing price is above the opening price.

How to build

  1. Select data.
  2. Go to tab "Insert" on the ribbon.
  3. Click the "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button.
  4. Click the "Open-High-Low-Close" button.