Adding a benchmark line to a graph, how to add horizontal benchmark target base line in an excel, combo chart column chart with target line exceljet, create convincing visualizations by adding reference lines, combo chart column chart with target line exceljet. Create convincing visualizations by adding reference lines, how to add a horizontal line to a chart in excel target, how to add horizontal benchmark target base line in an excel, combo chart column chart with target line exceljet, adding a benchmark line to a graph.

Hello,
I'm really really stuck on a frustrating issue and can not seem to find a solution. Any help would be greatly appreciated! What I want to do seems simple but I just can't get it to work. I'm trying to create a pivot graph with a target line set at '50' across the entire graph. It has to be a pivot graph because the data will change often and needs to be manipulated by people who are less familiar with Excel than myself.
I attached an example but you will see that my target is not displayed as a horizontal line but instead it's simply just another bar.
Thank you in advance to anyone that can assist me!
- Justin
Attached Files
  • Graph.xlsx‎ (16.7 KB, 163 views)

To add a vertical line to your line or scatter chart, do the following:

1. Add the date with current date to your data, for example:

2. To add a new data series to your chart, do one of the following:

  • On the Design tab, in the Data group, choose Select Data:
  • Right-click in the chart area and choose Select Data.. in the popup menu:

In the Select Data Source dialog box, click the Add button and in the Edit Series dialog box, type:

  • In the Series X values box - the cell with current date ($D$4)
  • In the Series Y values box - constant value (1):

3. If it is necessary, change data series:

  • Right-click in the new data series and choose Change Series Chart Type.. in the popup menu:
  • In the Change Chart Type dialog box, choose the Scatter type:

4. On the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose Error Bars list:

Excel propose several error bars, also you can use More Error Bars Options... If necessary, you can fine-tune the error bar settings from the Format Error Bars task pane:

If you change the date, the chart will be changed too:

Mailstore client download for mac. You can then make any other adjustments to get the expected look.

See also this tip in French: Comment ajouter une ligne verticale au graphique.