If you are having lots of historical stock data closing prices and now you need to visualise how it is going? But don’t know how to do this then you are at right place here I’ll tell you how to do this by using stock line chart in Excel.
Insert Stock Line Chart In Excel
Here is the given data source that I’m going to use to create the Stock Line Chart in my Excel to show you as an example:
To create this stock line chart, you will need 2 data point:
- The Date and,
To do this in your Excel follow these given steps, you will get how easy it is to insert a Stock Line Chart.
STEP1: Highlight Your Data
Firstly, you need to highlight your data of stock prices like this:
STEP2: Insert Stock Line Chart
After highlighting them follow this:
Go to Insert > Charts > Line
Here you will have a chart like this;
STEP3: Design Your Stock Line Chart
Now you will need to select the preferred design to make your chart more presentable by following this:
Click on your Chart > Go to Chart Design > Select Your Design