Creating reference band

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

In Kyvos XY family charts, you can use horizontal or vertical reference bands or lines as markers to compare data to specific values.

You can create reference lines or bands for:

• Left or right value axis for Bar and Line family charts. 

• Top or bottom value axis for column chart. 

• Left or bottom value axis for scatter chart. 

Using the reference band or line, you can specify the following:

• Start or end value for the reference band by defining a value or measure

• Place reference labels on charts, axes, or labels

• Set the background color

• Label reference lines or bands

• Define the style of the reference line

To add a reference band or line, perform the following steps. 

1. From the Toolbox, select Workbooks, then select a workbook and worksheet. 

2. Select Design if needed. 

3. In the Properties pane, scroll down if needed.

4. In the Reference Band/Line section, click the Left Axis or Right Axis link. 

5. The Create Reference Band/Line dialog box is displayed. 

   Open

   

6. Select the type as Band or line. 

   1. To create a reference band, do the following:

      1. Specify the start and end values using either the Value option (for numeric values) or the Measure option (for required measures).

      2. Set the background color. 

      3. Enter a label for a reference band. 

   2. To create a reference line, do the following: 

      1. Specify the value using either the Value option (for numeric values) or the Measure option (for required measures).

      2. Select the line style, line weight, and background color.

      3. Enter a label for a reference line. 

7. Choose the Axis, Chart, or Legend option to display the reference label you added.

8. Select the Include values in label checkbox if you want to to display the XY chart value where the reference band is set. 

9. Click Apply. 

Open