{"id":7447,"date":"2017-12-01T15:05:13","date_gmt":"2017-12-01T14:05:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=7447"},"modified":"2024-04-01T22:06:03","modified_gmt":"2024-04-01T20:06:03","slug":"stock-line-chart-using-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/stock-line-chart-using-excel\/","title":{"rendered":"Stock Line Chart Using Excel"},"content":{"rendered":"<p>Ever had a lot of historical stock data closing prices and you want to visualize how it is going so far?<\/p>\n<p>You can actually use the good old\u00a0<strong>Line Chart\u00a0<\/strong>in Excel to create your own\u00a0<strong>Stock Line Chart!<\/strong><\/p>\n<p>Below is the data source that we are going to use to create our Stock Line Chart\u00a0in Excel:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-00.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7453\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-00.png\" alt=\"Stock Line Chart Using Excel\" width=\"175\" height=\"300\" \/><\/a><\/p>\n<p>We need 2 data points to create this chart, the <strong>Date<\/strong> and the <strong>Close Price<\/strong>.<\/p>\n<p>In this example I show you how easy it is to insert a <strong>Stock <\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-slope-of-tangent-line-in-excel\/\" target=\"_blank\" rel=\"noopener\">Line Chart\u00a0using Excel<\/a>.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/QjgqUgGvWzk?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Stock-Line.xlsx<\/span><\/a><\/p>\n<div class=\"after-post-box\"><\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Highlight your data of stock prices:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7454\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-01.png\" alt=\"Stock Line Chart Using Excel\" width=\"208\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-01.png 208w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-01-184x300.png 184w\" sizes=\"(max-width: 208px) 100vw, 208px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Go to\u00a0<em><strong>Insert &gt; Line Charts &gt; Line<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7455\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-02.png\" alt=\"Stock Line Chart Using Excel\" width=\"848\" height=\"228\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-02.png 848w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-02-300x81.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-02-768x206.png 768w\" sizes=\"(max-width: 848px) 100vw, 848px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0<strong>Right click\u00a0<\/strong>on your Title and choose\u00a0<strong>Delete<\/strong>\u00a0as we do not need this.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7456\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-03.png\" alt=\"Stock Line Chart Using Excel\" width=\"471\" height=\"271\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-03.png 471w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-03-300x173.png 300w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Chart Tools &gt; Design\u00a0<\/strong><\/em>and select the preferred design to make your chart<strong>\u00a0<\/strong>more presentable!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7457\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-04.png\" alt=\"Stock Line Chart Using Excel\" width=\"809\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-04.png 809w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-04-300x79.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-04-768x201.png 768w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>And there you have it!\u00a0 Your own\u00a0<strong>Stock <\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/double-line-graph-in-excel\/\" target=\"_blank\" rel=\"noopener\">Line Chart in Excel!<\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone size-full wp-image-7458\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-05.png\" alt=\"Stock Line Chart Using Excel\" width=\"656\" height=\"299\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-05.png 656w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Stock-Line-05-300x137.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p><span style=\"color: #0000ff\"><strong>Create a Stock Line Chart<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-32.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Stock Line Chart Using Excel\" class=\"alignnone wp-image-7469 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/530-300-ultimate-guide.png\" alt=\"Stock Line Chart Using Excel\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/530-300-ultimate-guide.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/530-300-ultimate-guide-300x170.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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\u00a0Line Chart\u00a0in Excel to create your own\u00a0Stock Line Chart! Below is the data source that we are going to use to create our Stock Line Chart\u00a0in Excel: We [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17434,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Stock Line Chart Using Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,26],"tags":[160,99,317],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7447"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7447"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7447\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17434"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}