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!

Below is the data source that we are going to use to create our Stock Line Chart in Excel:

Stock Line Chart in Excel

We need 2 data points to create this chart, the Date and the Close Price.

In this example I show you how easy it is to insert a Stock Line Chart using Excel.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Highlight your data of stock prices:

Stock Line Chart in Excel

 

STEP 2: Go to Insert > Line Charts > Line

Stock Line Chart in Excel

 

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

Stock Line Chart in Excel

 

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

Stock Line Chart in Excel

 

And there you have it!  Your own Stock Line Chart in Excel!

Stock Line Chart in Excel

Create a Stock Line Chart

HELPFUL RESOURCE:

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...
Add Trendlines to Excel Charts With Excel Charts, it is very easy to create Trendlines for your data.  Trendlines show which direction the trend of your data is going, and gives you the trajectory as well. In this example, I show you how easy it is to insert a Trendline using an Excel Line Chart. DOWN...
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. One of the key reporting tools needed is the project milestone or timeline char...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...