Previous Topic  Next Topic

Format Solid Gauge

The Format Solid Gauge dialog helps you format solid gauges in a solid gauge chart. This dialog appears when you right-click on a solid gauge chart and select Format Graph from the shortcut menu.

The dialog contains the following tabs: Circular Graph, Axis, Pointer, Target, Frame, Range Color and Hint.

OK

Applies the changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Displays the help document about this feature.

Ignores the setting and closes this dialog.

Circular Graph

Specifies properties for arcs in the solid gauge.

Circular

Specifies the size of the arcs.

• Angle
  Specifies the degree for angles of the arcs. Select the angle of the gauge from the drop-down list or select Customized to open the Customize Gauge Angle dialog to specify the start angle and end angle.
• Thickness
  Specifies the thickness of the arcs, in inches.
• Hole Size
  Specifies the relative size of an arc in a percentage of total arc size.
• Start Style
  Specifies the style of the start graph of the arcs.
• End Style
  Specifies the style of the end graph of the arcs.

Fill

Specifies the color of the arcs.

• Color
  Specifies the color of the arcs.
• Color List
  Opens the Color List dialog to specify the color of the arcs.
• Transparency
  Specifies the transparency for color of the arcs.
• Background
  Specifies the background color of the arcs.
• Use Range Color
  Specifies whether to use the color you defined for the ranges as the color of the arcs. If checked, the Color, Color List and Transparency options will be disabled.

Border

Specifies properties for border of the arcs.

• Line Style
  Specifies the line style to apply to the border.
• Border Type
  Specifies the type of the border.
• Color
  Specifies the color of the border.
• Transparency
  Specifies the transparency for color of the border.
• Thickness
  Specifies the thickness of the border, in inches.

Axis

The tab consists of four sub tabs: Axis, Tick Mark, Label and Format.

Axis

Specifies properties of the axis in the solid gauge.

Show Axis

Specifies whether to show the axis in the solid gauge.

Type

Specifies the position relationship of the axis and the arcs.

• Inside
  If selected, the axis will be inside the arcs.
• Outside
  If selected, the axis will be will be outside the arcs.
• Center
  If selected, the axis will be in the center of the arcs.

Option

Specifies the values to display on the axis.

• Minimum Value
  Specifies the minimum value of the axis. You can also use a formula to control the property.
• Maximum Value
  Specifies the maximum value of the axis. You can also use a formula to control the property.

Line

Specifies the properties of the axis line.

• Color
  Specifies the color of the line.
• Style
  Specifies the style of the line.
• Transparency
  Specifies the transparency for color of the line.
• Thickness
  Specifies the thickness of the line.
• Use Range Color
  Specifies whether to use the color you define for the ranges as the line color. If checked, the Color and Transparency options will be disabled.

Gap

• Circular Axis Gap
  Specifies the gap between the axis and the arcs if the axis is displayed inside or outside of the arcs.

Tick Mark

Specifies properties of the tick marks on the axis.

Type

Specifies the type of the tick marks on the axis.

• None
  Specifies not to display the tick marks on the axis. It's meaningless to specify all the other tick mark related properties if this type is selected.
• Inside
  Specifies to display the tick marks inside the axis.
• Outside
  Specifies to display the tick marks outside the axis.
• Center
  Specifies to display the tick marks in the center of the axis.

Major Tick Mark Line

Specifies properties of the major tick mark line.

• Correlate with Axis
  If checked, the line properties of the major tick marks will correlate with that of the axis automatically.
  • Color
    Specifies the color of the major tick mark line. Disabled when Use Range Color in the Axis sub tab is checked.
  • Style
    Specifies the style of the major tick mark line.
  • Transparency
    Specifies the color transparency of the major tick mark line. Disabled when Use Range Color in the Axis sub tab is checked.
  • Thickness
    Specifies the thickness of the major tick mark line.
• Increment
  Specifies the distance between two adjacent major tick marks on the axis.
• Number of Tick Marks 
  Specifies how many major tick marks to be displayed on the axis.
• Tick Mark Length 
  Specifies the length of the major tick mark line.

Minor Tick Mark Line

Specifies properties of the minor tick mark line.

• Correlate with Axis
  If checked, the line properties of the minor tick marks will correlate with that of the axis automatically.
  • Color
    Specifies the color of the line. Disabled when Use Range Color in the Axis sub tab is checked.
  • Style
    Specifies the style of the line.
  • Transparency
    Specifies the color transparency of the line. Disabled when Use Range Color in the Axis sub tab is checked.
  • Thickness
    Specifies the thickness of the line.
• Increment
  Specifies the distance between two adjacent minor tick marks on the axis.
• Number of Tick Marks 
  Specifies how many minor tick marks to be displayed on the axis.
• Tick Mark Length 
  Specifies the length of the minor tick mark line.

Label

Specifies properties of the major tick mark labels.

Option

Specifies the type of the labels.

• None
  If selected, the labels will not be shown.
• Normal
  If selected, the labels will be shown as you specify.
  • Label Every N Major Tick Marks
    Specifies the frequency at which the major tick marks will be labeled.
  • Number of Major Labels
    Specifies how many major tick mark labels to be displayed on the axis.
    • Auto
      If checked, all major tick mark labels will be shown.
    • Fixed
      If checked, you can specify the number of major tick mark labels to be displayed on the axis.
• Range Value
  If selected, the labels will show the range values you define.
• Min and Max Value
  If selected, the labels will show the minimum value and maximum value defined in the Axis sub tab.

Gap

Specifies the gap properties for the data labels.

• Label Axis Gap 
  Specifies the distance between the data label and the axis, in inches.
• Best Effect
  Specifies whether to adjust the data labels automatically to make them placed best. If checked, some labels will be hidden when they are overlapped.

Font

Specifies the font format of text in the data labels.

• Font
  Lists all the available font faces that can be selected to apply to the text.
• Size
  Specifies the font size of the text.
• Fill Type
  Specifies the fill type of the text. It can be one of the following: none, color, texture and gradient.
• Color 
  Specifies the font color of the text. Disabled when Use Range Color in the Axis sub tab is checked.
• Font Style
  Specifies the font style of the text. It can be one of the following: plain, bold, italic, and bold italic.
• Transparency
  Specifies the transparency for color of the text. Disabled when Use Range Color in the Axis sub tab is checked.

Orientation

• Angle
  Specifies the rotation angle of the data labels.

Format

Specifies the data format of the major tick mark labels.

Category

Lists the category types. Select one to customize its format.

Format

Displays all the formats of the selected category. Select the required one and select Add to add it as the format of the specified category. You can add only one format for each category.

Properties

Displays the properties of the format you select. If the formats listed in the Format box cannot meet your requirement, define the format in the text box and then select Add to add it as the format of the specified category.

Auto Scale in Number

Specifies whether to automatically scale the major tick mark 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. 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.

Sample

Displays a preview sample of your selection.

Stack

Lists all the formats you select from different categories.

Add

Adds a format to the Stack list box.

Remove

Removes a format from the Stack list box.

Apply

Applies the specified format in the Stack list box to the major tick mark labels.

Pointer

Specifies properties of the pointers in the solid gauge.

Pointer Style

Specifies the style of the pointers.

• Arrow
  Specifies to use arrow as the pointer style.
  • Value Pointer
    Specifies the style of the value pointers. Select a style from the drop-down list or select Customized to specify another image as the value pointers in the Insert Image dialog.
  • Width
    Specifies the width of the arrow.
  • Height
    Specifies the height of the arrow.
• Mark
  Specifies to use mark as the pointer style.
  • Value Pointer
    Specifies the style of the value pointers. Select a style from the drop-down list or select Customized to specify another image as the value pointers in the Insert Image dialog.
  • Width
    Specifies the width of the marks.
  • Height
    Specifies the height of the marks.
  • Position
    Specifies the position of the mark relative to the arc.
  • Gap
    Specifies the distance between the mark and the arc, in inches.
• Style List
  Opens the Style List dialog to specify the style for pointers in the same data series respectively.

Pointer Color

Specifies color properties of the pointers.

• Color
  Specifies the color of the pointers.
• Color List
  Opens the Color List dialog for you to specify the pointer color.
• Transparency
  Specifies the transparency for color of the pointers.
• Use Range Color
  Specifies whether to use the color defined for the ranges as the pointer color. If checked, the three properties above will be disabled.

Pointer Value

Specifies the pointer value properties.

• Show Pointer Value
  Specifies whether to show the pointer values.
  • Position
    Specifies the position relationship between the values and the pointers. Select the position from the drop-down list. If customized is selected, the X and Y settings in the General tab of the Format Pointer Label dialog will take effect.

Pointer Border

Specifies the pointer border properties.

• Show Pointer Border
  Specifies whether to show the border of the pointers. When it is checked, the following border properties are enabled.
  • Line Style
    Specifies the line style to apply to the border.
  • Color
    Specifies the color of the border.
  • Transparency
    Specifies the transparency for color of the border.
  • Thickness
    Specifies the weight of the border, in inches.

Target

Specifies properties of the target in the solid gauge.

Use Target Value

Specifies whether to use the target value for the solid gauge.

• Target Value
  Specifies the target value. You can also use a formula to control the value.

Pointer Style

Specifies the pointer style for the target value.

• Target Pointer
  Specifies the style of the target pointer. Select a style from the drop-down list or select Customized to specify another image as the target pointer in the Insert Image dialog.
• Width
  Specifies the width of the target pointer.
• Height
  Specifies the height of the target pointer.
• Position
  Specifies the position of the target pointer relative to the arc.
• Gap
  Specifies the distance between the target pointer and the arc.

Pointer Color

Specifies color properties of the target pointer.

• Color
  Specifies the color of the target pointer.
• Transparency
  Specifies the transparency for color of the target pointer.

Target Value

Specifies properties of the target value.

• Show Target Value
  Specifies whether to show the target value on the solid gauge.
  • Position
    Specifies the position of the target value relative to the arc. Select the position from the drop-down list. If customized is selected, the X and Y settings in the General tab of the Format Target Label dialog will take effect.

Frame

Specifies properties for the frame of the solid gauge chart.

Size

Specifies the size properties of the frame.

• Frame Size
  Specifies the size of the frame.

Fill

Specifies the color and transparency of the frame.

• Fill
  Specifies the color to fill the frame.
• Transparency
  Specifies the transparency of the color to fill the frame.

Border

Specifies the properties for border of the frame.

• Line Style
  Specifies the line style to apply to the border.
• Border Type
  Specifies the type of the border.
• Color
  Specifies the color of the border. To change the color, select the color indicator to select a new color from the color palette, or select More Colors in the color palette to access the Color Picker dialog in which you can select a color within a wider range.
• Transparency
  Specifies the transparency for color of the border.
• Thickness
  Specifies the thickness of the border, in inches.

Gauge Group Name

Specifies properties for the gauge group name.

• Show Gauge Group Name
  Specifies whether to show names for the arcs in the solid gauge which are values of the field on its category axis. If the solid gauge contains no category field, the group name shows Report by default.
  • Position
    Specifies the position of the names relative to the arcs. Select the position from the drop-down list. If customized is selected, the X and Y settings in the General tab of the Format Gauge Label dialog will take effect.

Range Color

Specifies different colors to fill the arcs in solid gauge in different ranges.

Adds a new color range.

Removes the selected color range.

Minimum

Specifies the minimum value of the range.

Maximum

Specifies the maximum value of the range.

Color

Specifies the color schema of the range. Select in the color cell to select a color from the color palette, or select More Colors in the color palette to access the Color Picker dialog in which you can select a color within a wider range.

Name

Displays the name of the range.

Others

Specifies the properties for values that do not fall into any of the ranges you define.

• Name
  Specifies the name for the values.
• Color
  Specifies the color for the values. To change the color, select the color indicator to select a new color from the color palette, or select More Colors in the color palette to access the Color Picker dialog in which you can select a color within a wider range.

Hint

Specifies properties of the data marker hint.

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.

Previous Topic  Next Topic