Sorting
You can choose how to sort the horizontal axis of the scatter plot under the Chart tab in the Sort section.
Axes
The Axes section of the Chart tab is used to configure the Horizontal Axis and Vertical Axis.
- Add Label: When enabled, label text appears adjacent to the axis. You can also align the label text.
- Use Discrete Scale: Choose whether the axis should be formatted using a discrete scale instead of the default continuous scale.
- Customize Range: Specify a custom minimum and maximum value for the chart axis.
- Set Axis Line Location: When enabled, this option lets you control the position of the axis line. Auto places the axis line at the bottom of the chart (in the case of the horizontal axis) or the left of the chart (in the case of the vertical axis). Zero aligns the axis to the zero value and Hidden removes the axis line entirely. If this option is turned off, the chart's axis line will be displayed in a default location.
- Customize Ticks: When enabled, you can control which tick values will be displayed on the axis. Values lets you specify exact tick values, which should be separated with commas. Choose Count to set an approximate number of ticks (this option is only available on axes displaying continuous data). Or choose Hidden to remove ticks from the axis.
- Limit Tick Width: This is the maximum width, in pixels, applied to text on this axis. Leaving the tick width set to auto will result in tick text remaining on one line. Text wraps at spaces, so longer words will sometimes extend beyond the specified value.
- Limit Tick Characters: This feature allows you to set a maximum number of characters for tick labels. When enabled, longer labels will be truncated to fit the character limit, with ellipses displayed to indicate that the word has been truncated. You can specify a custom value or leave it at auto for default behavior.
- Rotate Ticks: On horizontal axes, you can rotate tick labels to angles of 0°, 30°, 45°, 60°, or 90°. This can improve readability, especially when dealing with long or overlapping tick labels.
- Use Short Format: On the dependent axis, you can display axis tick values in a compact format, such as 1K for 1,000 or 1M for 1,000,000.
The following chart formatting option applies to both axes:
- Clip Chart: Restrict chart items such as bars and symbols from extending beyond the boundaries of the chart container, ensuring all items remain within the outermost values on both axes.
Symbols
The Symbol section under the Chart tab can be used to manage the shape and size of the symbols displayed on the scatter plot:
Symbol Shape: Choose between Fixed, which assigns the same shape to all symbols, and Dynamic, which assigns shapes to symbols based on the value of a Symbol Shape Field (which must be a text field). If you choose to assign shapes dynamically, you can choose a symbol shape for every unique value in the selected field.
Symbol Size: Choose between Fixed, which lets you pick a fixed size for all symbols in the scatter plot, and Dynamic, which varies the size of each symbol based on a Symbol Size Field (which must be a number, percent, currency, or measurement field). If you choose to assign sizes dynamically, you can choose a Maximum Symbol Size, which is the size the symbol will be drawn when the value of the Symbol Size Field equals the Maximum Symbol Value. When the value of the Symbol Size Field is 0, the symbol will be drawn at 0px (i.e. will not be visible). For all other values, the symbol size is scaled proportionally.
Symbol Order Field: This field controls the layering of symbols on the chart. It allows you to specify which symbols should appear on top and which should be positioned beneath others. You can select a numeric or text field, which manages symbol ordering as follows:
- If you select a number, percent, currency, or measurement field, symbols with smaller Symbol Order Field values are placed beneath others (unless you select the "reversed" option, in which case they are placed above others).
- If you select a text field, symbols are layered alphabetically by their Symbol Order Field values, with values closer to the beginning of the alphabet layered at the bottom and values closer to the end of the alphabet layered at the top. Again, selecting the "reversed" option flips this order.