Hi Low Chart
Excel High Low
/hi_lo_close_stock_chart1-56a8f7de3df78cf772a24dda.gif "Hi Low Chart")
Most often found in stock market charts, the addition ofhigh/low lines help to point out how close actual values came to the goalpoints. All you need are at least two data series for you to add high/low linesto connect the maximum data point in a category with its corresponding minimumpoint. Bringing architecture to the next level pdf converter. For example, you can use high/low lines to compare actual expensesagainst budgeted expenses. To add high/low lines in Excel, follow these steps:. Openthe line chart that graphs budgeted and actual expenses over the last 12 months. Right-clickone of the lines, and select Format Data Series.
Circulon Hi Low System
Inthe Options tab, click the High/Low Lines check box, and click OK.If you wish to change the format of the resulting lines, double-clickone of the high/low lines and select Format High/Low Lines to access the Formatdialog box. Miss a tip?Check out the, and catch up on our most recent Excel tips.Help users increase productivity by for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.