Applies to:Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
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
Info
Any reference line or band added to a worksheet is also included when exporting charts in PDF format.
To add a reference band or line, perform the following steps.
- From the Toolbox, select Workbooks, then select a workbook and worksheet.
- Select Design if needed.
- In the Properties pane, scroll down if needed.
- In the Reference Band/Line section, click the Left Axis or Right Axis link.
- The Create Reference Band/Line dialog box is displayed.
- Select the type as Band or line.
- To create a reference band, do the following:
Specify the start and end values using either the Value option (for numeric values) or the Measure option (for required measures).
- Set the background color.
- Enter a label for a reference band.
- To create a reference line, do the following:
- Specify the value using either the Value option (for numeric values) or the Measure option (for required measures).
- Select the line style, line weight, and background color.
- Enter a label for a reference line.
- To create a reference band, do the following:
- Choose the Axis, Chart, or Legend option to display the reference label you added.
- Select the Include values in label checkbox if you want to to display the XY chart value where the reference band is set.
- Click Apply.