Previous Topic  Next Topic

Format Legend

The Format Legend dialog helps you to format the legend of a chart. It contains the following tabs: General, Placement, Border, Font and Label.

OK

Applies the settings and closes this dialog.

Cancel

Cancels the settings and closes this dialog.

Help

Displays the help document about this feature.

General

This tab shows some general information of the chart legend.

Name

Specifies the display name of the chart legend.

Show NLS Value

Specifies to show the translated name for the display name of the chart legend in the Name text box if you have enabled the NLS feature and translated it.

If checked, this option takes effect only when the display name of the chart legend is not modified.

X

Specifies the X coordinate of the chart legend. Available only when the Placement option in the Placement tab is set to customized.

Y

Specifies the Y coordinate of the chart legend. Available only when the Placement option in the Placement tab is set to customized.

Width

Specifies the width of the chart legend. Available only when the Placement option in the Placement tab is set to customized.

Height

Specifies the height of the chart legend. Available only when the Placement option in the Placement tab is set to customized.

Fill Type

Specifies the type for filling the chart legend.

Color

Indicates the background color of the chart legend.

To change the color, select the color indicator to access the Select Color dialog and then specify a new color, or input a color string in the format #RRGGBB. If you want to make the background transparent, input Transparent in the text box.

Transparency

Specifies the transparency of the legend background color.

Show Value

Specifies whether to show the value of each legend.

Show Percent

Specifies whether to show the percentage of each legend.

Show Tips

Specifies whether to show the corresponding data information when the mouse pointer points at a target in the chart legend.

Placement

This tab shows the position-related information of the chart legend.

Placement

Specifies the position of the legend to be left, right, top, bottom or customized by dragging on the chart manually.

Secondary Placement

Specifies the position of the legend on the basis of the Placement property.

Label Vertical Spacing

Specifies the vertical distance between two adjacent legend labels.

Label Horizontal Spacing

Specifies the horizontal distance between two adjacent legend labels.

Top Margin

Specifies the distance between the legend labels and the top border of the legend.

Bottom Margin

Specifies the distance between the legend labels and the bottom border of the legend.

Left Margin

Specifies the distance between the legend labels and the left border of the legend.

Right Margin

Specifies the distance between the legend labels and the right border of the legend.

Reverse Labels

Specifies whether or not to arrange the legend labels in a reverse order.

Border

This tab shows information about borders of the chart legend.

Line Style

Specifies the line style of the legend borders.

Border Type

Specifies the type of the legend borders.

Color

Specifies the color of the legend borders.

Transparency

Specifies the color transparency of the legend borders.

Thickness

Specifies the thickness of the legend borders.

Font

This tab shows the font-related information of the chart legend.

Font

Specifies the font face of the legend labels.

Size

Specifies the font size of the legend labels.

Fill Type

Specifies the fill type of the legend labels.

Color

Specifies the color of the legend labels.

Transparency

Specifies the color transparency of the legend labels.

Font Style

Specifies the font style of the legend labels.

Font Effect

Specifies the font effect of the legend labels.

Font Underline

Specifies the style of the line under the legend labels.

Font Strikeout

Specifies whether or not to attach a strikeout line to the legend labels.

Font Rotation

Specifies the rotation angle of each legend label around its center, in degrees.

Font Shearing

Specifies the shearing transformation of each legend label around its center, in degrees.

Word Wrap

Specifies whether or not to enable word wrapping for the label text.

Label

Specifies the text of the legend entry labels. This tab is available only when the legend entry labels show the values of the field displayed on the category or series axis of the chart.

Auto

If checked, the legend entry labels display values of the category/series field. You can uncheck it to customize the label text.

• Label Text
  Specifies the text of the legend entry labels. Input the desired label text manually or select to select a field from the drop-down list to use its values as the label text.

Auto Scale in Number

Specifies whether to automatically scale the legend entry 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 platform.

Previous Topic  Next Topic