Peltier Technical Services, Inc.
- Custom Excel Solutions
Jon's Excel and Charting Pages
- Jon's Charts
- Tutorials
- Excel
- Site Index and Search
- RSS
|
Peltier Technical Services, Inc. Jon's Excel and Charting Pages |
|
Add a Horizontal or Vertical Line to a Column or Line Chart.
Excel Dashboards by ExcelUser.com - Instructional eBook and Ready-to-Use Workbooks.
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. Jon's Excel and Charting Pages Peltier Technical Services, Inc., Copyright © 2008. All rights reserved. |
Waterfall Chart
Box and Whisker
