Skip to main content

Data settings form in the Chart Editor

Suggest edit Updated on October 29, 2021

For each drop zone in the Chart Editor, you can define column-specific format settings by using the Data settings form. The available options depend on the chart type and the type of data in that column.

FieldChart typesDetails
Number formatAll Select one of the following options for number formatting:
  • General
  • Decimal
  • Currency
  • Percent
  • Custom

Expand this field to display additional options. The number format that you select governs some settings in the additional options. Conversely, if you change some of the settings in the additional options, the Number format option changes to Custom.

Depending on the number format that you select, the following optional fields are available:

  • Scale – Select None, Number, or Time to specify the values along the axis against which the data is plotted. If you select None, no axis values display.
  • Decimal Places – Select Auto or a number.
  • Force Decimals? – Select the check box to force a zero to display in the decimal fields, even if the number has no decimal value.
  • Prefix – Provide a prefix for the displayed data.
  • Suffix – Provide a suffix for the displayed data.
  • Separators – Specify whether to display numbers by using commas (1,000) or periods (1.000).
Axis labelAllSpecify a label to display along the axis, or along the bar in a bar chart.
Bar width ratioBar Set the percentage of the chart the bars can cover. For example, 0.9 means that 90 percent of the area is bars, with the rest as background.
Show low/high valuesSpark lineSelect the check box to show the lowest and highest values for the chart.
Show open/close valuesSpark lineSelect the check box to show the values at the start and end of the selected period.
Limit to topPie, Bar, Column, Line, Area For a pie chart, specify the maximum number of pie pieces. You can specify that there is no limit.

For a bar or column chart, specify a maximum number of one of the values displayed in the chart.

Grid linesBar, Column, Line, AreaSelect the check box to display grid lines.
Grid labelsBar, Column, Line, AreaSelect the check box to display grid line labels.
Data tooltipBar, Column, Line, AreaSelect the check box to display a tooltip when the user hovers the mouse over a chart value.
Treat blank as zeroBar, Column, Line, AreaSelect to treat blank status values for a particular date and time as zero.
Show all labelsPie Select to show labels for all pie pieces. Expand this field to display the following additional options:
  • Data – Select to display data for each pie piece.
  • Data Tooltip – Select to display a data tooltip when the user hovers the mouse over a pie piece.

If you select Data, the following additional label options are available:

  • Data placement – Specify whether data displays outside the chart or as a call-out.
  • Include value – Select the check box to display the value in the chart segment.
  • As percent? – Select the check box to display the value as a percentage of the total.
  • Include name – Select the check box to display the name of the data object.
  • Data tooltip – Select the check box to enable a tooltip that displays information about the value.
FormatAllSelect a format for the pie slices or category labels.
Series formatBar, Column, Combo, Line, AreaSelect a format for the bar or column label.
Grid labelsBar, Column, Line, AreaSelect the check box to display labels for the grid lines.
OrientationBar, Column, Line, AreaSpecify whether labels on the axis display vertically or horizontally.
Line weightLineSpecify the width of the data lines in pixels.
Minimum labelGaugeSpecify the lowest labeled value on a gauge.
Maximum labelGaugeSpecify the highest labeled value on a gauge.
Minimum valueGauge, Bar, Column, Line, AreaSpecify the lowest measurement on a gauge.
Maximum valueGauge, Bar, Column, Line, AreaSpecify the highest measurement on a gauge.
Tick locationGaugeSpecify whether the ticks, or unit indicators, on a gauge display inside or outside of the gauge.
Show tick valuesGaugeSelect the check box to display the numeric value of each tick on the gauge.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us