|
Books that I own and use while developing in Excel |
|
2008 US East Coast Excel User Conference |
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.