In this section: |
Data labels highlight important data points on a chart. They identify exact numbers. You can customize data labels in a variety of ways to make them stand out more clearly on the chart. For example, you can change the position, angle, color, or size of data labels.
In this section: |
Whether you access data label options from the ribbon or the right-click menu, you are presented with a dialog box of options. The following dialog boxes are commonly used for formatting data labels:
For instructions on how to open these dialog boxes, see the procedures in Using Data Labels Properties.
The Format Labels dialog box contains options for editing data labels. Bar, line, and area charts share the same tabs.
The Format Labels dialog box contains the following tabs:
Use the General Options tab to add data labels to a chart and set their position, angle, and radius. The General Options tab is shown in the following image.
The General Options contains the following options:
Note: You can control the display of currency symbols in your chart using the syntax editor. Using the SET CURRSYMB command, you can specify a value for a particular currency which will display in your chart. Supported currencies include: US Dollar (USD), British Pound (GBP), Japanese Yen (JPY), Euro (EUR), and New Israeli Shekel (NIS). This capability applies to all formats for charts.
Use the Advanced tab to modify additional data labels properties. The Advanced tab is shown in the following image.
The Advanced tab contains the following options:
There are some options in the General Options tab that are specific to stack charts. The General Options tab for a stack chart is shown in the following image.
These options specific to a stack chart are:
Bubble and stock charts share the same General Options and Advanced tabs as bar, line, and area charts, except for the Custom Label option.
For pie charts, the General Option and Advanced tabs are replaced by the Pie Labels and Pie Title tabs.
Use the Pie Labels tab to customize your pie data labels. The Pie Labels tab is shown in the following image.
The Pie Labels tab contains the following options:
Feeler Line
The Format Labels drop-down menu provides a list of preset formats that you can apply to labels. When you select a custom format, it must be defined using a custom format pattern. The following table describes the characters that you can use in a custom format.
Character |
Description |
---|---|
# |
Is a digit. |
0 (zero) |
Shows as absent. |
. (period) |
Is a placeholder for decimal separator. |
, (comma) |
Is a placeholder for grouping separator. |
; (semicolon) |
Separates formats. |
- (dash) |
Is the default negative prefix. |
% (percent) |
Divides by 100 and shows as a percentage. |
x |
Determines that any other characters can be used in the prefix or suffix. |
‘ (apostrophe) |
Is used to quote special characters in a prefix or suffix. |
Use the Pie Title tab to create and style a pie title. The Pie Title tab is shown in the following image.
The Pie Title tab contains the following options:
Use the Funnel Labels tab to customize the labels on a funnel or a pyramid chart. The Funnel Labels tab is shown in the following image.
The Funnel Labels tab contains the following options:
Feeler Line
The Style dialog box contains options to style the data labels. The Style dialog box is shown in the following image.
The Style dialog box contains the following options:
Note: Reset only works while the Style dialog box is open. Once you click OK, all changes are committed. To undo global styling after it has been committed, you must use the Undo command on the Quick Access Toolbar.
The Line Style dialog box contains options to style lines on a chart. The Line Style dialog box is shown in the following image.
The Line Style dialog box contains the following options:
When you right-click a data label on a bar, line, or area chart, a menu of the following options opens:
The right-click menu contains options that are available on the Series tab.
When you right-click a data label on a pie chart, a menu of the following options opens:
In this section: |
The following sections contain procedures for customizing data labels. The procedures are organized by the tab and group in which their associated options appear on the ribbon.
The Properties group contains commands for enhancing charts, such as changing the type or adding a trendline, for the selected series.
The data labels appear, and are formatted and styled accordingly.
The following image shows a chart with data labels.
WebFOCUS |