Add High/Low Lines To Your Excel Charts

Dennis Faas's picture

You can analyze the data in Excel by creating high/low lines for your data charts, allowing you to easily view parameters in a given range.

High/low lines are most often found in stock market charts. They help to point out how close actual values came to the goal points. You will need at least two data series to add high/low lines to connect the maximum data point in a category with its corresponding minimum point. For example, you can use high/low lines to compare actual expenses against projected expenses.

Follow the steps below to learn how to add High/low lines in MS Excel:

  1. Open the line chart that graphs projected and actual expenses over the past 12 months.
  2. Right-click one of the lines, and select Format Data Series.
  3. In the Options tab, click the High/Low Lines check box, and click OK.

To change the format of the resulting lines, double-click one of the high/low lines and select Format High/Low Line.

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
Average: 5 (1 vote)