Pinterest Pixel

Candlestick Chart Using Excel

Stock Data Analysis is no easy feat!  Once you have a lot of historical stock data it’s hard... read more

Download Excel Workbook
Bryan
Posted on

Overview

Candlestick Chart Using Excel | MyExcelOnline Candlestick Chart Using Excel | MyExcelOnline

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:

Candlestick Chart Using Excel

 

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

Candlestick Chart Using 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.

Candlestick Chart Using Excel | MyExcelOnline
Download excel workbookCandlestick.xlsx

STEP 1: Highlight your data of stock prices:

Candlestick Chart Using Excel

 

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

Candlestick Chart Using Excel

 

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

Candlestick Chart Using Excel

 

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

Candlestick Chart Using Excel

 

And there you have it! Your own Candlestick Chart!

Candlestick Chart Using Excel

Further Learning:

If you like this Excel tip, please share it
Candlestick Chart Using Excel | MyExcelOnline Candlestick Chart Using Excel | MyExcelOnline
Candlestick Chart Using Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  In-Cell Bar Charts with the REPT Function

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...