![]() ![]() When you become a member at, you have access to this and many, many more articles that include screenshots. To change the format of the resulting lines, double-click one of the high/low lines and select Format High/Low Line. ![]() In the Options tab, click the High/Low Lines check box, and click OK.Right-click one of the lines, and select Format Data Series.Open the line chart that graphs projected and actual expenses over the past 12 months.For example, you can use high/low lines to compare actual expenses against projected expenses.įollow the steps below to learn how to add High/low lines in MS Excel: 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. They help to point out how close actual values came to the goal points. In the unit section, mark the Major value as 50000. Set the value of Minimum Bound as 300000. High/low lines are most often found in stock market charts. Select the Chart Go to Format Tab on the ribbon Choose Horizontal Axis in the Current Selection Group Click on Format Selection Button This will open the Format Axis Pane for Horizontal Axis. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |