Adding a Value Range 

Use

You can define a value range that should be highlighted in the chart. You can define a minimum, optimum and maximum value within the value range. These values are displayed in the chart with a line and can be assigned a title.

Prerequisites

The axis to which the value range belongs is a value axis and is displayed in the chart. See Showing and Hiding Axes.

Procedure

  1. Click with the right mouse key on the value axis (normally the Y axis).
  2. In the context menu choose Add Value Range.
  3. You go to the Format Value Range dialog box.

  4. Repeat the following steps for all the values (minimum, optimum, maximum) you want to mark in the chart:
  5. Enter a title for the relevant value.
  6. Define where the value should lie:
  1. Choose OK.