## Add vertical benchmark line to excel chart

This short tutorial will walk you through adding a line in Excel graph such as an average line, benchmark, trend line, etc. In the last week's tutorial, we were looking at how to make a line graph in Excel.In some situations, however, you may want to draw a horizontal line in another chart to compare the actual values with the target you wish to achieve. As I said, adding a vertical line in a chart is useful when you want to highlight a specific data point in your chart. There are also some other ways to add a vertical line but I found this method quick and easy. I hope this charting tip will help you to get better at Excel. Add horizontal benchmark/target/base line by Paste Special in Excel chart. This method will guide you to copy the benchmark/target/baseline data to the destination chart as a new data series, and then change the chart type of the new series to Scatter with Straight Line in Excel.

## To add it to the chart, right click the chart and click Select Data, then select the column with your benchmark # (make sure the # is in every cell) and you'll see it added as part of your histogram. Right click on that series and change the series chart type to a line chart.

### This short tutorial will walk you through adding a line in Excel graph such as an average line, benchmark, trend line, etc. In the last week's tutorial, we were looking at how to make a line graph in Excel.In some situations, however, you may want to draw a horizontal line in another chart to compare the actual values with the target you wish to achieve.

4 Sep 2018 Today we are learning how to add a vertical line on the gantt chart representing current or any other specific date for better understanding of the  A clustered chart can be combined with a line chart by selecting a segment of a series The 100% chart is a variation of a stacked column chart with all columns typically adding up to All category cells in the datasheet contain numbers and Excel's cell format is The line chart can also display a second vertical value axis. Chart are always used to analyze information. In this article we demonstrate how to add horizontal average line to vertical chart in Excel. You can add a reference line, band, distribution, or box plot to identify a specific value, region, or range on a continuous axis in a Tableau view. For example, if  Before you create a trendline: You can add trendlines to bar, line, column, or scatter charts. On your computer, open a spreadsheet in Google Sheets. Double- click

### Add vertical line to bar chart. 1. Select your data range, and click Insert > Bar > Bar . 2. Then go to a blank cell, here I select Cell A10 to type Y, and then go to the cell next to the Y cell, here is Cell B10 to type X. see screenshot: 3. In the two cells below Y cell, type 0 and 1 in each cell.

With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and 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 my Excel chart whilst I am presenting the data to my stakeholders. need to add a vertical line to a horizontal graph as shown in the picture but unable to do so Sub gph() lrow = ThisWorkbook.Sheets("InputData").Cells(Rows.Count, 1).End(xlUp).Row Charts.Add ActiveChart.ChartType = xlBarStacked ActiveChart.SetSourceData Source:=Sheets("InputData").Range("A1:B" &