Searching...

Total Subscribers Receiving Our Weekly Excel Lessons

+75,000

# Candlestick Chart Using Excel

Stock Data Analysis is no easy feat!  Once you have a lot of historical stock data it’s hard to visualize the trend using technical analysis.

Thankfully Excel has a lot of stock charts to help you with that, and one of them is the Candlestick Chart!

A Candlestick Chart has a vertical line that indicates the range of low to high prices and a thicker column for the opening and closing prices:

Below is the data source that we are going to use in Excel:

You need a Date column which should be the first column.

Then this should be followed by a Open, High, Low, and Close column. This is the exact order that needs to be followed in order to create the Candlestick Chart.

In this example I show you how easy it is to insert this using Excel.

STEP 1: Highlight your data of stock prices:

STEP 2: Go to Insert > Stock Charts > Open-High-Low-Close

STEP 3: Right click on your Legend and choose Delete as we do not need this.

STEP 4: Go to Chart Tools > Design and select the preferred design to make your chart more presentable!

And there you have it! Your own Candlestick Chart!

Create a Candlestick Chart

### Related Posts:

Stock Line Chart Using Excel Ever had a lot of historical stock data closing prices and you want to visualize how it is going so far?You can actually use the good old Line Chart in Excel to create your own Stock Line Chart! ...
Project Milestone Chart Using Excel Project Management is no easy feat!  There are lots of moving parts, long hours and constant reporting.It requires you to keep everybody on the same page and focused on the goals and timelines. ...
Create a Radar Chart in Excel For Performance Revi... Radar Charts in Excel are very handy to show a rating on several performance areas.When I had to give out performance reviews, it was a very helpful snapshot for me to show to my colleagues how th...
Draw a Logo with a Scatter Chart in Excel Scatter Charts in Excel could be used for fun in situations where your boss is away and you have nothing else to do but learn the undoubted power of Microsoft Excel!I was just playing around with ...
Searching...

DO YOU WANT TO GET BETTER AT EXCEL?
If so, join over 75,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!