Skip to main content

Data Label Editor Dialog

  • Updated
Not yet followed by anyone

BackPrevious Topic Next TopicNext

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.

Data Label Editor

The following are details about options in the editor.

Toolbar

You can use the following toolbar buttons to edit the format of the data labels.

  • Insert Drop-down List button Insert Drop-down List
    Inserts a drop-down list into the editor.
  • Font Face button Font Face
    Specifies the font face of the text in the selected object.
  • Font Size buttonFont Size
    Specifies the font size of the text in the selected object.
  • Style buttonStyle
    Specifies the style group applied to the selected object.
  • Bold buttonBold
    Specifies whether or not to bold the text in the selected object.
  • Italic buttonItalic
    Specifies whether or not to italicize the text in the selected object.
  • Underline buttonUnderline
    Specifies whether or not to underline the text in the selected object.
  • Justify buttonJustify
    Adjusts horizontal spacing so that the content is aligned evenly along both the left and right margins in the selected object.
  • Left buttonLeft
    Aligns the content of the selected object to the left boundary of the object.
  • Center buttonCenter
    Aligns the content of the selected object to the center of the object.
  • Right buttonRight
    Aligns the content of the selected object to the right boundary of the object.
  • Background Color buttonBackground Color
    Specifies the background color of the selected object on the color palette.
  • Foreground Color buttonForeground Color
    Specifies the foreground color of the selected object on the color palette.
  • Format Box buttonFormat 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.

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.

OK

Applies the settings and closes the dialog.

Cancel

Cancels the settings and closes the dialog.

Help

Displays the help document about this feature.

BackPrevious Topic Next TopicNext