Data settings form in the Chart Editor
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.
Field | Chart types | Details |
---|---|---|
Number format | All |
Select one of the following options for number formatting:
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:
|
Axis label | All | Specify a label to display along the axis, or along the bar in a bar chart. |
Bar width ratio | Bar |
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 values | Spark line | Select the check box to show the lowest and highest values for the chart. |
Show open/close values | Spark line | Select the check box to show the values at the start and end of the selected period. |
Limit to top | Pie, 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 lines | Bar, Column, Line, Area | Select the check box to display grid lines. |
Grid labels | Bar, Column, Line, Area | Select the check box to display grid line labels. |
Data tooltip | Bar, Column, Line, Area | Select the check box to display a tooltip when the user hovers the mouse over a chart value. |
Treat blank as zero | Bar, Column, Line, Area | Select to treat blank status values for a particular date and time as zero. |
Show all labels | Pie |
Select to show labels for all pie pieces. Expand this field to display the following additional options:
If you select Data, the following additional label options are available:
|
Format | All | Select a format for the pie slices or category labels. |
Series format | Bar, Column, Combo, Line, Area | Select a format for the bar or column label. |
Grid labels | Bar, Column, Line, Area | Select the check box to display labels for the grid lines. |
Orientation | Bar, Column, Line, Area | Specify whether labels on the axis display vertically or horizontally. |
Line weight | Line | Specify the width of the data lines in pixels. |
Minimum label | Gauge | Specify the lowest labeled value on a gauge. |
Maximum label | Gauge | Specify the highest labeled value on a gauge. |
Minimum value | Gauge, Bar, Column, Line, Area | Specify the lowest measurement on a gauge. |
Maximum value | Gauge, Bar, Column, Line, Area | Specify the highest measurement on a gauge. |
Tick location | Gauge | Specify whether the ticks, or unit indicators, on a gauge display inside or outside of the gauge. |
Show tick values | Gauge | Select the check box to display the numeric value of each tick on the gauge. |