Cool Vertical Line In Excel Graph
Sometimes you need to add a horizontal line to your chart.
Vertical line in excel graph. In some empty cells set up the data for the vertical line like shown below. Take a look at this. Unfortunately adding a vertical line to a bar chart isnt a simple feat in Excel but Ill step you through a workaround thats relatively painless.
To add a vertical line to your line or scatter chart do the following. Select the single point from column C on the charts this may be fiddly. Eg this will be useful to show data with some goal line or limits.
In this post Im going to show you a way to create an Excel bar chart with a vertical line. Select your data and make a bar chart Insert tab Charts group Insert Column or Bar chart 2-D Bar. Follow the steps on how to add a vertical line in Excel graph below.
Now enter a value 100 for Jan in Ver Line column. - Create the chart as Excel defaults to. Select the range A1C13.
This video will help you to create vertical line in excel chartPicture Lookup in excelhttpsyoutubegfOYJrY4fmQAdvance Dynamic Vlookup in Excelttps. This tip will help you to extend those charts by a vertical line that shows the current date. How to create a simple Bullet graph in Excel.
I suggest you start as you did in Excel generating a line chart categories along the x-axis and value along the y-axis. Enter your email address below to download the sample. The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes.