Most often found in stock market charts, the addition of
high/low lines help to point out how close actual values came to the goal
points. All you need are at least two data series for you 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 budgeted expenses. To add high/low lines in Excel, follow these steps:

  1. Open
    the line chart that graphs budgeted and actual expenses over the last 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.

If you wish to change the format of the resulting lines, double-click
one of the high/low lines and select Format High/Low Lines to access the Format
dialog box.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.