XY Chart

Use the XY Chart widget to display points that show the relationship between two sets of data.

XY Chart widget properties

Use this property To do this
General tab
Name

Type an internal name for the widget.

Connection Name

Specify a connection to a data source.

Scope Type Make the connection public or specify a named session.
Title Type a title for the XY Chart widget box. If necessary, adjust the appearance of the title.
Title Bar Visibility

Specify the visibility of the widget title bar. Choose one of the following:

  • Above
  • Overlay
  • Hidden (outside Designer only)
Context Sensitivity

Specify the context sensitivity.

  • Choose from the following:
    • None
    • Receives Context
    • Provides Context
    • Custom

    Context can be received and provided on the X-axis values.

    Context can be received on the following:

    • The Y-axis values

    • For any of the axis, X-axis, Y-axis and secondary Y-axis, context can be received on the following:

      • Any constant lines

      • Any shaded regions

To specify context sensitivity options, click to access the context sensitivity properties.

Tile tab
Background Color Specify the background color of the list.
Text Color Specify the color of text in the list.
Show Shadow Display a shadow on the widget.
Show Title Row Border Display borders around the title row of the widget.
Font Size Specify the size of the widget title.
Font Preview Shows you how your font selections will affect the widget title.
Bold Display the widget title text in bold.
Italic Display the widget title text in italics.
Series tab
X Axis Values or Labels Specify values or labels to use for the X axis.
  1. Click .

    A blank field is displayed.

  2. Construct the query as necessary. See Statement Editor Functions for a list of available functions.
Series Click Add Series to add a chart series. Click the Properties icon to edit the chart series properties.
Chart Series Properties (General tab)
Name Type a name for the series.
Description (if differs from Name) Type a description for the series.
Type

Defaults to Bar. Specify a different series type, if necessary. Choose from the following:

  • Bar
  • Area
  • Line
  • Point (Scatter)
  • Stacked Bar
  • Stacked Area
  • Full Stacked Bar
  • Full Stacked Area
  • Full Stacked Line
  • Range Bar
  • Range Area (River)
  • Bubble
  • Step Area
  • Step Line
Series Color Specify a color for the series.
Y Axis Values or Upper Limits Click and specify the data to use for the Y axis or an upper limit to the data range.
Y Axis Lower Limits or Bubbles Sizes Click and specify a lower limit to the data range or the data to use to control the bubble size for the Bubble series type.
Chart Series Properties (Labels tab)
Show Labels Display labels for the series. These are the labels displayed within the chart, not the axis labels.
Show for Zero Values Select the check box to display labels for data in the series with zero values.
Show Connector Lines Display small lines to connect the labels with points on the series.
Label

Specify the value to display on the label. Use curly brackets to specify parameter values.

Click to adjust the label value format. For example, you can change the format from a number to a percentage.

Position

Specify the position of the label in relation to the chart data. Choose from the following:

  • Outside
  • Inside
Chart Series Properties (Tooltips tab)
Show Tooltips Select the check box to display tooltips when you hover over chart elements. By default, this is set to the same state as the Show Tooltips field on the XY Chart Properties > Options > Other tab.
Label

Specify the value to display as a label. Use curly brackets to specify parameter values.

Click to adjust the label value format. For example, you can change the format from a number to a percentage.

Chart Series Properties (Markers tab)
Show Point Markers Display visual markers on the chart elements to identify data points.
Symbol

Specify a symbol to use for the point markers. Choose from the following:

  • Circle
  • Square
  • Diamond
  • Triangle Up
  • Triangle Down
  • Cross
Size Specify a numerical value to control the size of the markers.
Chart Series Properties (Bubble tab)
Bubble Min Size Specify a numerical value to control the minimum size of chart bubbles.
Bubble Max Size Specify a numerical value to control the maximum size of chart bubbles.
Chart Series Properties (Options tab)
Show on Secondary Y Axis Display the Y axis on the right side of the chart.
Show in Legend Include the series name in the chart legend.
Ignore Null/Empty Points Don't include points associated with null or empy values in the series.
Smooth Curves Display sequences of data points on line charts using curves instead of hard angles.
Options > Axes (X, Y, and Secondary Y tabs)
Show Axis Select the check box to show the axis.
Title Type a title for the XY Chart widget box. If necessary, adjust the appearance of the title.
Label

Specify the value to display on the label. Use curly brackets to specify parameter values.

Click to adjust the label value format. For example, you can change the format from a number to a percentage.

Font Size Specify the size of the axis label.
Font Preview Shows you how your font selections will affect the axis label.
Bold Display the axis label in bold.
Show Grid Lines If you want to display grid lines for the axis, select the Show Grid Lines check box.
Discrete Axis Value If the values are separate and distinct (not continuous), select the Discrete Axis Value check box.
Label Overflow (X tab only)

Specify how to display overlapping labels on the X axis.

  • Choose one of the following:
    • Hide — only display labels that don't overlap.
    • None — don't adjust overlapping labels. Allow them to overlap.
    • Rotate — rotate the labels to keep them from overlapping. Use the Overlap Rotate property to adjust the degree of rotation.
    • Stagger — display alternating labels on two separate lines in the axis area of the chart.

      Depending upon how many data points are included in the series, some labels may be hidden.

Overlap Rotate (X tab only) If you set Label Overflow to Rotate, specify the degree of rotation.
Overlap Stagger (X tab only) If you set Label Overflow to Stagger, specify the amount of space to display between the label lines.
Zoom and Scroll (X tab only) Select the check box to zoom in on and scroll the label.
Always Show Zero on Axis (Y and Secondary Y tabs only) Select the check box to display a zero at the point at which the two axes intersect.
Min Specify a minimum value for the axis.
Max Specify a maximum value for the axis.
Swap X and Y Axes Substitute the X axis for the Y axis.
Constant Lines Add constant lines.
  1. Click Add Constant Line.
  2. In the New Constant Line dialog box, for Label, type a label.
  3. For Color, specify the color to use for the line.
  4. For Value, click , and then construct a query as necessary.
  5. For Conditions, click Add Statement, and then construct a query as necessary.
  6. For Label Position, choose one of the following:
    • Hidden
    • Away From Axis, Negative Side
    • Away From Axis, Positive Side
    • On Axis, Negative Side
    • On Axis, Positive Side
  7. Click OK.
Strip Lines Add strip lines.
  1. Click Add Strip Line.
  2. In the New Strip Line dialog box, for Label, type a label.
  3. For Color, specify the color to use for the line.
  4. For Minimum Value, click , and then construct a query as necessary.
  5. For Maximum Value, click , and then construct a query as necessary.
  6. For Conditions, click Add Statement, and then construct a query as necessary.
  7. Click OK.
Options > Legend tab
Show Legend

Select the check box to display a legend. Adjust the remaining fields on the tab as necessary.

Label

Specify the value to display on the label. Use curly brackets to specify parameter values.

Click to adjust the label value format. For example, you can change the format from a number to a percentage.

Position Specify where the legend should appear relative to the chart.
Orientation Select whether the legend should be oriented vertically or horizontally.
Columns Select the number of columns to include. The default is auto.
Rows Select the number of rows to include. The default is auto.
Text Position Select where the legend item labels should appear relative to the legend entries.
Margin Select how much margin space should separate the legend from the edge of the chart.
Padding Select how much margin space should surround the legend.
Options > Colors tab
Use Color Palette Choose a predefined color palette to apply to the chart.
Match Colors to Labels Select the check box to match the chart labels to the palette colors.
Options > Crosshair tab
Show Crosshair

Select the check box to display a crosshair.

Adjust the following:

  • Indicator on X Axis
  • Indicator on Y Axis
  • Color
Options > Tooltips tab
Show Tooltips (Default) Select the Show Tooltips check box to display tooltips.
Options > Other tab
Single-Selection Mode Select the check box to turn on single selection mode.
Show Animation Select the check box to show animation on the chart.
K/M/B Summarization (Default) Select to display large numbers in summarized notation.
Show Series Labels (Default) Select the check box to show the series labels.
Font Size Specify the size of the series label.
Font Preview This text gives you a preview of how your font selections will affect the series label.
Bold Display the series label in bold.
Show Tooltips Select the check box to display tooltips when you hover over chart elements.
Font Size Specify the size of the tooltips.
Font Preview This text gives you a preview of how your font selections will affect the tooltips.
Bold Display the tooltips in bold.
Overlapping Labels

Specify how to handle overlapping labels.

  • Choose from the following:
    • Overlap
    • Hide
    • Move
Advanced tab
Conditions Specify any conditions that must be met to return a value.
  1. Click Add Statement.

    A blank statement is displayed.

  2. Construct the query as necessary.
Sort By Filter the data to further narrow the scope of the query.
  1. Click Add Statement.

    A blank statement is displayed.

  2. Construct the query as necessary.
  3. Click Sort Ascending or Descending to adjust the order of displayed records.
Button Visibility tab
Refresh Show or hide the Refresh button on the widget toolbar.
Show/Hide Legend Show or hide the Show/Hide Legend button on the widget toolbar.
Events tab
Add Event Handler Add events to the widget.
  1. For When/On, specify when you want the event to occur.
  2. For Then, specify the action that you want to occur.

Last modified: Friday May 12, 2023

Is this useful?