How to create a candlestick chart
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
- Select data.
- Go to tab "Insert" on the ribbon.
- Click the "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button.
- Click the "Open-High-Low-Close" button.
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
English
Spanish