• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Stock Chart in Excel

Home » Excel » Excel Charts » Stock Chart in Excel

By Harshada Khot Leave a Comment

Stock Chart in Excel

Stock chart in excel is also known as high low close chart in excel because it used to represents the conditions of data in markets such as stocks, the data is the changes in the prices of the stocks, to use this chart in excel we can insert it from insert tab and also there are actually four types of stock charts in excel, high low close is the most used one as it has three series of price high end and low, we can use upto six series of prices in stock charts.

Excel Stock Chart (Table of Contents)

  • What is Stock Chart
  • How to Create?

Stock Chart in Excel

If you are a trader of the stock market then you must be already using the spreadsheet for your daily price tracking. Not many of us worried about the stock market at all because of the lack of knowledge in it. Just by looking at the data we don’t see much of the impact of stock prices on a daily basis. When it comes to stock market we can see four kinds of prices, first one is “Opening Price”, the second one is “High Price”, the third one is “Low Price” and fourth one is “Closing Price”.

If we can plot the graph for all these four numbers we can easily identify the impact of the stock price of different companies. In this article, we will show you how to create a stock chart with excel.

What are Stock Charts in Excel?

As the name itself says Stock Charts it shows the volatile prices of stock market prices of companies. Stock Chart doesn’t mean you can use it only for stock market volatility we can also use this for seasonal rail fall, temperature variations, etc

In order to create this chart, we need to have proper data on stock prices on daily-wise. We need to have an opening price, a high price in the day, the low price in the day, and what is the close price in the day. So for our demonstration purpose, I have created the below data of stock prices.

Stock Chart in Excel Example

With this data now we will build a stock chart in excel.

How to Create a Stock Chart in Excel?

Let’s see the example of a stock chart to understand it better.

You can download this Stock Chart Excel Template here – Stock Chart Excel Template

Follow the below steps to create your first Stock Chart.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Step 1: Select the data in the worksheet.

Step 2

Step 2: Go to INSERT > Stock Chart > Open-High-Low-Close.

Stock Chart in Excel Step 0.3.1.1

Step 3: Now we will have chat like the below.

Step 0.4

Step 4: Select the vertical axis and press Ctrl + 1.

Stock Chart in Excel Step 0.5

Step 5: In the format data series box make minimum as 50 and Maximum as 65. Major to 1.

 Step 6

Step 6: Now enlarge the chart vertically and horizontally. We will have a chart like below.

Stock Chart in Excel Step 0.7

In this chart we can see for each date we have the box with upward and downward arrows. Upward and downward arrows represent opening and closing stock prices for each date, but we don’t know exactly which is opening and which is closing stock price. The reason why we cannot say which is opening and which is closing because there are situations where an opening is more and closing is less and vice-versa.

So, how do we identify which is opening price and which is the closing price?

Some boxes have filled color and some don’t, in order to identify which is open and which is close we need to rely on these boxes.

“If the box is non-filled then the opening price is downward arrow” i.e. stock is profitable for the day.

“If the box is filled then the upward arrow is opening price” i.e. stock is under loss for that day.

The continuous line of an upward arrow indicates the high price for the day and continued line of a downward arrow indicates the low price for the day.

Like this using Stock Chart, we can analyze the charts and make some interpretations. We have four kinds of stock charts available with excel, below are types.

“High – Low – Close”, “Open – High – Low – Close”, “Volume – High – Low – Close”, and “Volume – Open – High – Low – Close”.

Based on the structure of the data we can choose the appropriate one to show the numbers in the graph.

Recommended Articles

This has been a guide to Stock Chart in Excel. Here we learn how to create a stock chart in excel with Example and downloadable excel template. You can learn more about excel functions from the following articles –

  • Marimekko Chart in Excel (Mekko)
  • Control Charts in Excel
  • Calculate Average with Multiple Criteria in Excel
  • Use Excel as a Calculator
  • 2D Stacked Bar Chart in Excel
  • Create Tornado Chart in Excel
  • Top 5 Types of Pie Chart in Excel
  • Create Flow Chart in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Excel Charts

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Stock Chart Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Excel VBA Bundle (35 Courses with Projects) View More