|
|
|
Add a Horizontal or Vertical Line to a Column or Line Chart.
How do you add a horizontal or vertical line to a column or line chart, to show a target value, or the series average? The method involves adding a new series, applying it to the secondary axes, and making the secondary axes disappear. A variation uses an error bar for the straight line, rather than the connecting line between two points. Add a Horizontal Line to a Column or Line Chart: Series Method. Add a Vertical Line to a Column or Line Chart: Series Method. Add a Horizontal Line to a Column or Line Chart: Error Bar Method. Add a Vertical Line to a Column or Line Chart: Error Bar Method. |
Peltier Technical Services, Inc.Excel Chart Add-Ins | Training | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2017. All rights reserved. |
