How to Create Stock Charts in Excel for Mac 2011


show more Creating stock charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Creating stock charts

Businesses and individuals invest in the stock market, whether trying to invest for retirement or to make a profit from cash on hand. Excel is a great application for tracking stock prices. So in this movie, I will show you how to format your data so you can create stock charts. Excel let's you create a number of stock charts. The limitation is that your data must be set up in exactly the right format for each of them. Let me show you what I mean. The data that I have here in this worksheet has five columns. I have the date that the measurements were taken. Then I have Open, High, Low, and Close.

So as you might suspect, in Excel you can create what's called an Open-High-Low-Close stock chart. So with a cell selected in my data set, I will go up to Charts, and then there is no stock chart here in the main body of the Ribbon, so I need to click Other, and then here at the top, you see that I have a series of stock charts of High-Low-Close, Open- High-Low-Close, Volume-High-Low-Close,...

Creating stock charts
Video duration: 4m 11s 6h 32m Beginner

Viewers:

Creating stock charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...