Data Label Editor Dialog
The Data Label Editor helps you to edit data labels in the range groups of a chart. It appears when you select Edit Data Labels in the Data Label sub tab of the Range tab in the Format Category (X) Axis dialog.
The following are details about options in the editor.
You can use the following toolbar buttons to edit the format of the data labels.
- Insert Drop-down List
Inserts a drop-down list into the editor.
- Font Face
Specifies the font face of the text in the selected object.
- Font Size
Specifies the font size of the text in the selected object.
Specifies the style group applied to the selected object.
Specifies whether or not to bold the text in the selected object.
Specifies whether or not to italicize the text in the selected object.
Specifies whether or not to underline the text in the selected object.
Adjusts horizontal spacing so that the content is aligned evenly along both the left and right margins in the selected object.
Aligns the content of the selected object to the left boundary of the object.
Aligns the content of the selected object to the center of the object.
Aligns the content of the selected object to the right boundary of the object.
- Background Color
Specifies the background color of the selected object on the color palette.
- Foreground Color
Specifies the foreground color of the selected object on the color palette.
- Format Box
Specifies the format of the values in the selected object.
- Auto Scale in Number
Available when the selected object is of the Number data type. It specifies whether to automatically scale the object values that fall into the two ranges:
- When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
- When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale the values.
By default it is set to auto which means that the setting follows that of the chart. When it is true, the specified format applies to the integer part of the values after scaled, but if the specified format conflicts with Auto Scale in Number, for example the values are displayed in percentage, then the Auto Scale in Number setting is ignored.
- Auto Scale in Number
Data label edit box
You can edit the data labels you want to display on the range groups in this box. The box works like a special text box. A line in the box is a chart iterator, which is a special paragraph with markers or text.
To edit the data labels, select the information to show for each data label from the corresponding data label drop-down list. Select the Insert Drop-down List button to insert more data labels if the existing ones cannot meet your requirement. To delete a data label, select it and press Backspace on the keyboard.
To insert an iterator after an existing iterator, select on the existing iterator to select it, then press the Enter key on the Keyboard. You can edit the content in a selected chart iterator, such as adding, deleting, or modifying markers and text segment in it. To edit the properties of an iterator, select it, right-click on the blank space and select Chart Iterator from the shortcut menu to edit the iterator in the Chart Iterator dialog.
Applies the settings and closes the dialog.
Cancels the settings and closes the dialog.
Displays the help document about this feature.