Skip to main content

Format Pie

  • Updated

BackPrevious Topic  Next TopicNext

Format Pie

The Format Pie dialog helps you to format the pies of a pie chart. This dialog appears when you right-click a pie chart and select Format Graph from the shortcut menu.

Format Pie dialog

Pie

Specifies the properties of the pies.

  • Show Pie Name
    Specifies whether to show the names of the pies.

Static Data Label

Specifies the properties of the static data labels on the pies.

  • Show Static Data Label
    Specifies whether to show the static data labels on the pies. Only when it is true can the following static data label related properties work.
  • Style
    Specifies the display type for data values in the static data labels.
    • Value
      Shows the value for each pie section.
    • Category Name
      Shows the category name for each pie section.
    • Percent
      Shows the percentage of each pie section to the total.
    • Value and Percent
      Shows the value and the percentage for each pie section.
    • Category Name, Value
      Shows the category name and value for each pie section.
    • Category Name, Percent
      Shows the category name and percentage for each pie section.
    • Category Name, Value, Percent
      Shows the category name, value and percentage for each pie section.
  • Position
    Specifies the position of the static data labels on the pies.
    • Autofit
      If selected, the static data labels will be displayed automatically.
    • Sticker
      If selected, the static data labels will be displayed beside the pie sections.
    • Slim Leg
      If selected, the static data labels will be displayed beside the pie sections and pointed by thin lines.
      • Line Color
        Specifies the color of the thin lines that are used to point to the static data labels.
    • Best Fit
      If selected, the static data labels will be displayed at the best fit position automatically.
    • On Slices
      If selected, the static data labels will be displayed on the pie sections (slices).
  • Auto Scale in Number
    Specifies whether to automatically scale the static data labels that are of the Number data type when the label values 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.

KPI Value

Specifies the properties for the KPI values of the pies.

  • Show KPI Value
    Specifies whether to show KPI value for each pie.
    • KPI Value
      Specifies the KPI value to display on each pie. By default, the total value of each pie will be used as the KPI value. If you want to customize the value, uncheck Auto and input a value in the text box, or select Formula button and select a formula or summary from the drop-down list to use its value as the KPI value.
    • Position
      Specifies the position of the KPI value at the center, top, bottom of each pie or customized which allows for setting the X and Y properties to change the position.

Graph Border

Specifies the properties for the border of the pies.

  • Show Border
    Specifies whether to show the border of the pies. When it is checked, the other border properties will be enabled.
    • Line Style
      Specifies the line style to apply to the border.
    • Color
      Specifies the color of the border.
    • Thickness
      Specifies the thickness of the border.
    • Transparency
      Specifies the transparency for color of the border.

Hint

Specifies the data marker hint properties.

  • Show Category and Series
    Specifies whether to include the category and series values in the data marker hint.
  • Auto Scale in Number
    Specifies whether to automatically scale the values displayed in the data marker hint that are of the Number data type when the values 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.

OK

Applies the changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help button

Displays the help document about this feature.

Close button

Ignores the setting and closes this dialog.

BackPrevious Topic  Next TopicNext