Fine Beautiful Excel Horizontal Line

Now suppose we would like to add a horizontal line at y 20.

Excel horizontal line. Add a new data series to your chart by doing one of the following. On the Chart Design tab in the Data. But first we need a chart that looks like this.

Right-click anywhere on the existing chart and click Select Data. On the Format Data Series pane go to Fill Line tab Line section and select No line. You need to transpose your rows and columns from horizontal list to vertical list.

Check the Transpose box in the Paste Special dialog box. Convert horizontal to vertical with formula. You will be using this file each time you need to add.

THE SECOND WAY My Personal Preference. If you do not want to add the columns you can do the following. Create a PNG image 660 by 3 pixels and color it in some shade of gray.

The line is not selectable. It does not occupy any area. It is a line looking the same as a border line and is positioned exactly on the gridline between two rows.

Sometimes you need to add a horizontal line to your chart. 1 insert your chart 2 Right-click on it and choose Select Data Source from the drop-down menu 3 Select your series on the left hand side of the dialog box 4 Click on Hidden and Empty Cells. You would now see your horizontal data be transposed to vertical style.