Fantastic Excel Graph Vertical Line
Excel 2016 365 2013 2010 2007.
Excel graph vertical line. The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes. The inspiration was taken from this Tableau chart by Emily Tesoriero. Change the Vertical Axis maximum value to match the value from column C.
Insert a column in the table. Add the date with the current date to your data for example. In cells G20G21 I entered 9 in each as shown below.
In this post Im going to show you a way to create an Excel bar chart with a vertical line. Right click a column in the chart and select Format Data Series in the context menu. Can you have a vertical line graph in Excel 2003.
Excel Bar Chart with Vertical Line. - Choose the option you want. Edit the text labels on both the x and y axes to -90.
Select your data and make a bar chart Insert tab Charts group Insert Column or Bar chart 2-D Bar. Select the range A1C13. Horizontal bar category and N to the.
Download the featured file here. August 8 2019 by Mynda Treacy 9 Comments. Eg this will be useful to show data and highlight a current date.