high/low lines

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: Open the line ... (view more)