Previous Topic
Format Legend
The Format Legend dialog box is used to format the legend of a chart.
There are the following tabs in this dialog box: General, Placement, Border, Font and Label.
OK
Applies the settings and closes this dialog box.
Cancel
Cancels the settings and closes this dialog box.
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
Select this option to show the translated name for the display name of the object in the Name text box if you have enabled the NLS feature and translated it.
If selected, this option takes effect only when the display name of the object 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 box and then specify a new color, or type a color string in the format #RRGGBB. If you want to make the background transparent, type 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 selected, the legend entry labels display values of the category/series field. You can clear it to customize the label text.
- Label Text
Specifies the text of the legend entry labels. Type 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.