Peltier Technical Services, Inc.
 

Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog


Peltier Tech Chart Utility

 

 

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.

 

 

Page copy protected against web site content infringement by Copyscape

 

Peltier Tech Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.


Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2014. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile