{"id":5017,"date":"2021-01-31T02:05:23","date_gmt":"2021-01-31T01:05:23","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5017"},"modified":"2024-04-30T19:28:45","modified_gmt":"2024-04-30T17:28:45","slug":"interactive-vertical-column-in-your-excel-line-chart","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/interactive-vertical-column-in-your-excel-line-chart\/","title":{"rendered":"Add an Interactive Vertical Column in Your Excel Line Chart"},"content":{"rendered":"<p>In <strong>Excel, <\/strong>it is very easy to add vertical date line Excel chart\u00a0and make it interactive with a Scroll Bar!<\/p>\n<p>The reason why I do this is to <strong>use the vertical column to highlight a specific point <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">in the Excel chart<\/a><\/strong> whilst I am presenting the data to my stakeholders.<\/p>\n<p>Mmmm Steak \ud83d\ude42<\/p>\n<p>In this example, I show you how easy it is to add vertical date line excel chart &amp; sprinkled with a little magic using three different methods:<\/p>\n<ul>\n<li><a href=\"#add-vertical-line-using-shapes\"><strong>Add Vertical Line using Shapes<\/strong><\/a><\/li>\n<li><a href=\"#add-vertical-line-using-xy-scatter-plot\"><strong>Add Vertical Line using XY Scatter Plot<\/strong><\/a><\/li>\n<li><a href=\"#add-vertical-line-using-additional-column-series\"><strong>Add Vertical Line using Additional column series<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at each of these methods one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<p>This is our data:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5021\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-01.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"231\" height=\"384\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-01.png 231w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-01-180x300.png 180w\" sizes=\"(max-width: 231px) 100vw, 231px\" \/><\/a><\/p>\n<h3><em><strong>Want to know How To Add Vertical Date Line Excel Chart?<\/strong><\/em><\/h3>\n<p>*** Watch our video and step by step guide with a free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/m-C4a0Em3i0?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<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/m-C4a0Em3i0\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\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=\"alignright 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><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Interactive-Vertical-Column.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Interactive-Vertical-Column.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Interactive-Vertical-Column.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><a id=\"add-vertical-line-using-shapes\"><\/a>Add Vertical Line using Shapes<\/span><\/h3>\n<p>The easiest way to add vertical line to Excel chart is to <strong>draw a line on top of the Excel Chart<\/strong> using shapes. Follow the steps on how to add a vertical line in Excel graph below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span><strong>Select the data<\/strong> that will be used to create a chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22520\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"426\" height=\"474\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png 426w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94-270x300.png 270w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong>\u00a0<\/span>Go to <strong>Insert &gt; Line Charts &gt; Line with Markers<\/strong>.<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22522\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"945\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png 945w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93-300x134.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93-768x343.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong>\u00a0<\/span>Go to <strong>Insert &gt; Illustrations &gt; Line.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-95.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22524\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-95.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"853\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-95.png 853w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-95-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-95-768x306.png 768w\" sizes=\"(max-width: 853px) 100vw, 853px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Draw the line on top of the Chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-96.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22525\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-96.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"542\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-96.png 542w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-96-300x199.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong> <\/span>To increase the weight of the vertical line, Go to <strong>Shape Format<\/strong> &gt; <strong>Shape Outline<\/strong> &gt; <strong>Weight<\/strong> &gt;<strong> 3\/4 pt<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-97.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22526\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-97.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"951\" height=\"526\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-97.png 951w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-97-300x166.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-97-768x425.png 768w\" sizes=\"(max-width: 951px) 100vw, 951px\" \/><\/a><\/p>\n<p>This will excel add vertical line to chart!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-98.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22527\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-98.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"545\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-98.png 545w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-98-300x187.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/a><\/p>\n<p>Even though this method is super easy, it comes with its own drawback.<\/p>\n<p>This line is not linked to the data and hence <strong>will not change when you change the data<\/strong>. So, you will <strong>have to adjust<\/strong> this line as and when you update the data.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><a id=\"add-vertical-line-using-xy-scatter-plot\"><\/a>Add Vertical Line using XY Scatter Plot<\/span><\/h3>\n<p>To highlight a point in your chart, you can clearly define its position on the x-axis and create a vertical line for that plot.<\/p>\n<p>In this example, we will be using a scatter chart to highlight the period in the chart that has the maximum sales. Let&#8217;s see how it can be done:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span><strong>Select the data<\/strong> that will be used to create a chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22520\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"426\" height=\"474\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94.png 426w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-94-270x300.png 270w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong>\u00a0<\/span>Go to <strong>Insert &gt; Line Charts &gt; Line with Markers<\/strong>.<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22522\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"945\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93.png 945w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93-300x134.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-93-768x343.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/p>\n<p>This is how your sales chart will look like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-114.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22540\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-114.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"500\" height=\"316\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-114.png 500w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-114-300x190.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Now, insert the data for your vertical line highlighting the period that achieved the maximum sales.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong>\u00a0<\/span>In cells D6 and D7, use the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> below to extract the sales period with the maximum sales amount.<\/p>\n<p><strong><span style=\"color: #339966\">=MATCH(MAX(B5:B16),B5:B16,0)<\/span><\/strong><\/p>\n<p>Here, the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/max-formula-in-excel\/\" target=\"_blank\"><strong>MAX Formula<\/strong><\/a> will return the largest sales amount in the array provided and the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-match-function-intro\/\" target=\"_blank\" rel=\"noopener\"><strong>MATCH Formula<\/strong><\/a> will return the relative position of the maximum value in the array.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-115-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22542\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-115-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"532\" height=\"365\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-115-1.png 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-115-1-300x206.png 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong>\u00a0<\/span>In cells E6 and E7, type the value 0 and 1 respectively.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-116.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22543\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-116.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"523\" height=\"326\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-116.png 523w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-116-300x187.png 300w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong>\u00a0<\/span>Click on the chart and then Go to <strong>Chart Design<\/strong> Tab &gt; <strong>Select Data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22544\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"1182\" height=\"130\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117.png 1182w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117-300x33.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117-1024x113.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-117-768x84.png 768w\" sizes=\"(max-width: 1182px) 100vw, 1182px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong>\u00a0<\/span>In the Select Data Source dialog box, click on the <strong>Add<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-118.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22545\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-118.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"584\" height=\"323\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-118.png 584w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-118-300x166.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 7:<\/strong>\u00a0<\/span>In the Edit Series dialog box, select cell <strong>D4 for the <em>Series name <\/em><\/strong>box and cells <strong>D6:D7 for the <em>Series Values<\/em><\/strong> box. Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-120.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22546\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-120.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"335\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-120.png 335w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-120-300x143.png 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 8:<\/strong> <\/span>Go to <strong>Chart Design<\/strong> &gt; <strong>Change Chart Type<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22548\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"1179\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122.png 1179w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122-300x33.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122-1024x111.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-122-768x83.png 768w\" sizes=\"(max-width: 1179px) 100vw, 1179px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 9:<\/strong> <\/span>In the Change Chart Type dialog box, select <strong>Scatter with Straight Line<\/strong> and check the box for the <strong>secondary axis<\/strong>. Click OK.<\/p>\n<p><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-123-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22551\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-123-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"633\" height=\"599\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-123-1.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-123-1-300x284.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/a><\/strong><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 10:<\/strong> <\/span>Again, Go to Chart Design&gt; Select Data to open the Select Data dialog box. Select <strong>Period with Maximum Sales<\/strong> and then click on the <strong>Edit<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-124.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22552\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-124.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"583\" height=\"322\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-124.png 583w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-124-300x166.png 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 11:<\/strong> <\/span>In the Edit Series dialog box, select cells <strong>D6 and D7 for X values<\/strong> and <strong>E6 and E7 for Y values<\/strong>. Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-125.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22553\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-125.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"335\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-125.png 335w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-125-300x174.png 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/a><\/p>\n<p>You will a vertical line for the sales period 6 has been created but it<strong> does not extend to the top of the chart.<\/strong> Let&#8217;s change that and <strong>remove the secondary <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-axis-labels-in-excel\/\" target=\"_blank\" rel=\"noopener\">axis label<\/a><\/strong> as well!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-136.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22562\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-136.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"498\" height=\"314\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-136.png 498w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-136-300x189.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 12:<\/strong> <\/span>Right-click on the secondary axis and select <strong>Format Axis<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-127.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22557\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-127.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"751\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-127.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-127-300x149.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 13:<\/strong> <\/span>In the <strong>Format Axis<\/strong> dialog box, select the<strong> Maximum bound as 1<\/strong> and the <strong>Label Position as None<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-128.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22558\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-128.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"263\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-128.png 263w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-128-172x300.png 172w\" sizes=\"(max-width: 263px) 100vw, 263px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-129-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22559\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-129-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"257\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-129-1.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-129-1-155x300.png 155w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/a><\/p>\n<p>Your vertical column highlighting the maximum sales is now ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-131-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22565\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-131-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"505\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-131-1.png 505w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-131-1-300x194.png 300w\" sizes=\"(max-width: 505px) 100vw, 505px\" \/><\/a><\/p>\n<p>This <strong>line is dynamic<\/strong> as well. In this updated sales data, the <strong>highest sales are now achieved in the sales period 2<\/strong>. The <strong>Line chart, as well as the vertical column, gets updated<\/strong> based on the new data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-132.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-22564\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-132.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"1010\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-132.png 1010w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-132-300x109.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-132-768x278.png 768w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><a id=\"add-vertical-line-using-additional-column-series\"><\/a>Add Vertical Line using Additional column series<\/span><\/h3>\n<p>The last method is to use an additional column for the vertical line. Let&#8217;s dive into a step-by-step tutorial on how to add vertical line in Excel graph:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Add a new column <strong>Vertical Line<\/strong>, and place in the first value as <strong>100.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5022\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-02.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"326\" height=\"382\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-02.png 326w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-02-256x300.png 256w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select the entire table, go to\u00a0<em><strong>Insert &gt; Line Charts &gt;\u00a0Line with Markers<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5023\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-03.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"952\" height=\"609\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-03.png 952w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-03-300x192.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-03-768x491.png 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Select the chart and go to <em><strong>Design &gt; Change Chart Type &gt; Combo &gt; Custom Combination<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5024\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-04.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"751\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-04.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-04-300x63.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0For the <em>Vertical Line<\/em> series, change the Chart Type to\u00a0<strong>Clustered Column\u00a0<\/strong>and check\u00a0<strong>Secondary Axis. \u00a0<\/strong>Press<strong> OK.<\/strong><\/p>\n<p>(This will transform the Vertical Line series into a vertical column\u00a0in your chart.<\/p>\n<p>Make sure the <em>SALES PERIOD<\/em> and <em>SALES<\/em> are <strong>Line with Markers<\/strong> Chart Types).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5025\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-05.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-05.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-05-300x284.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span>\u00a0<strong>Double click<\/strong> your Secondary Axis to view the Format Axis Panel.<\/p>\n<p>Set\u00a0<strong>Maximum\u00a0<\/strong>to 100, to ensure our Vertical Line extends all the way to the top since we placed in the value of 100.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5026\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-06.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"898\" height=\"514\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-06.png 898w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-06-300x172.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-06-768x440.png 768w\" sizes=\"(max-width: 898px) 100vw, 898px\" \/><\/a><\/p>\n<p>Click on <strong>Labels<\/strong> and\u00a0change the\u00a0<strong>Label Position\u00a0<\/strong>to\u00a0<strong>None.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5027\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-07.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"341\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-07.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-07-205x300.png 205w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong><\/span>\u00a0Just to clean up our chart, notice there is a <strong>Sales Period Series.<\/strong><\/p>\n<p>Right click on it and click\u00a0<strong>Delete. \u00a0<\/strong>We do not need this.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5028\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-08.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"593\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-08.png 593w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-08-300x199.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 7:<\/strong><\/span>\u00a0<strong>Double click on the vertical bar<\/strong>, so that we can make it slimmer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5029\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-09.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"924\" height=\"395\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-09.png 924w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-09-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-09-768x328.png 768w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/a><\/p>\n<p>In the\u00a0<strong>Format Data Point <\/strong>pane, Set\u00a0<strong>Gap Width\u00a0<\/strong>to\u00a0<strong>500%.\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5030\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-10.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"879\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-10.png 879w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-10-300x173.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-10-768x444.png 768w\" sizes=\"(max-width: 879px) 100vw, 879px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 8:<\/strong><\/span>\u00a0Now it is time to try out our interactive chart!<\/p>\n<p>Drag and drop the Vertical Line value of 100 into another Sales Period and see the column chart move!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"size-full wp-image-5031 alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-11.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"984\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-11.png 984w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-11-300x122.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-11-768x312.png 768w\" sizes=\"(max-width: 984px) 100vw, 984px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 9:<\/strong><\/span>\u00a0There is a cooler trick and we can make the Vertical Bar become\u00a0<strong>Dynamic!\u00a0<\/strong>For this we need the\u00a0<strong>Developer Tab.<\/strong><\/p>\n<p>If you do not have the Developer Tab enabled yet, it is very easy to enable this first. \u00a0Go to <strong>File &gt; Options<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5045\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-19.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"206\" height=\"641\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-19.png 206w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-19-96x300.png 96w\" sizes=\"(max-width: 206px) 100vw, 206px\" \/><\/a><\/p>\n<p>Go to\u00a0<strong>Customize Ribbon &gt; Main Tabs &gt;\u00a0Developer. \u00a0<\/strong>Check this and click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5034\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-12.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"826\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-12.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-12-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-12-768x630.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP <\/strong><\/span><span style=\"color: #ff0000\"><strong>10:<\/strong><\/span>\u00a0Go to <strong>Developer &gt; Insert &gt; Form Controls &gt; Scroll Bar.\u00a0<\/strong>Drag this horizontally on top of the graph.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5035\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-13.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"599\" height=\"270\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-13.png 599w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-13-300x135.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP <\/strong><\/span><span style=\"color: #ff0000\"><strong>11:<\/strong><\/span>\u00a0Right click on the scroll bar and select\u00a0<strong>Format Control.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5036\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-14.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"549\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-14.png 549w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-14-300x208.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP <\/strong><\/span><span style=\"color: #ff0000\"><strong>12:<\/strong><\/span>\u00a0Set the\u00a0<strong>Maximum Value to 12.\u00a0<\/strong>This will depict our sales periods from 1 to 12.<\/p>\n<p>For the <strong>Cell link<\/strong>, place in <strong>$D$5,\u00a0<\/strong>this will show the value of the Scroll bar in this cell (i.e. which sales period it&#8217;s pointing to). \u00a0Press\u00a0<strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5037\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-15.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"937\" height=\"431\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-15.png 937w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-15-300x138.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-15-768x353.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP <\/strong><\/span><span style=\"color: #ff0000\"><strong>12:<\/strong><\/span>\u00a0In the Vertical Line column, place in this formula: <strong>=IF(A5=$D$5,100,&#8221;&#8221;)<\/strong><\/p>\n<p>What this will do, is simply check if the Sales Period matches the value of the Scroll bar ($D$5).<\/p>\n<p>If <strong>YES<\/strong>, then set the value to <strong>100<\/strong>.<\/p>\n<p>Setting the value to 100 will then make our vertical line show up in that Sales Period!<\/p>\n<p>Now the pieces are almost all in place!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-16-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5051\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-16-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"961\" height=\"488\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-16-1.png 961w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-16-1-300x152.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-16-1-768x390.png 768w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP <\/strong><\/span><span style=\"color: #ff0000\"><strong>13:<\/strong><\/span>\u00a0<strong>Double click the lower right corner<\/strong> of the formula cell, which will\u00a0copy the same formula down\u00a0the entire column.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-17-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone size-full wp-image-5047\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-17-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"381\" height=\"425\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-17-1.png 381w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-17-1-269x300.png 269w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Your interactive chart is now complete!!!<\/p>\n<p>Try playing around with the scroll bar and see the Vertical Line move with it! Cool hey?<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-18-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add an Interactive Vertical Column in Your Excel Line Chart\" class=\"alignnone wp-image-5048 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-18-1.png\" alt=\"Add an Interactive Vertical Column in Your Excel Line Chart\" width=\"960\" height=\"409\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-18-1.png 960w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-18-1-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Vertical-Line-18-1-768x327.png 768w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/61-excel-charts-examples\/\" target=\"_blank\" rel=\"noopener\">61 Excel Charts Examples!<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-radar-chart-for-performance-reviews\/\" target=\"_blank\" rel=\"noopener\">Create an Excel Radar Chart For Performance Reviews<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/\" target=\"_blank\" rel=\"noopener\">Bubble Chart with 3 Variables On A Chart<\/a><\/li>\n<\/ul>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In Excel, it is very easy to add vertical date line Excel chart\u00a0and make it interactive with a Scroll Bar! The reason why I do this is to use the vertical column to highlight a specific point in the Excel chart whilst I am presenting the data to my stakeholders. Mmmm Steak \ud83d\ude42 In this [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14861,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Add an Interactive Vertical Column in Your Excel Line Chart","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,25,26],"tags":[94,197],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5017"}],"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=5017"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5017\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14861"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}