|
Peltier Tech
Excel Dashboards
|
Horizontal Line Across a Column Chart.
For a newer, more detailed approach, see Add a Horizontal or Vertical Line to a Column or Line Chart or go straight to the new pages:
This page has been retained for compatibility with old links. Example posted after sufficient encouragement from Debra Dalgleish. How do you add a nice horizontal line on a column 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. Start with a column chart, like this: ![]()
![]() ![]() ![]() ![]() There's your column chart with a horizontal line, just the way you wanted. For a zipped workbook that shows this technique, click here. |
Peltier Technical Services, Inc.Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2010. All rights reserved. |