Skip to main content

Format Solid Gauge

  • Updated

BackPrevious Topic  Next TopicNext

Format Solid Gauge

The Format Solid Gauge dialog helps you to format a solid gauge chart. It 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.

Help

Displays the help document about this feature.

Circular Graph

Specifies properties for arcs in the solid gauge.

Format Solid Gauge dialog - Circular Graph

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.

Format Solid Gauge dialog - Axis - Axis tab

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.
  • Maximum Value
    Specifies the maximum value of the axis.

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.

Format Solid Gauge dialog - Axis - Tick Mark

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.

Format Solid Gauge dialog - Axis - Label

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.

Format Solid Gauge dialog - Axis - Format

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 platform. 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.

Format Solid Gauge dialog - Pointer

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.
    • Thickness
      Specifies the weight of the border, in inches.
    • Transparency
      Specifies the transparency for color of the border.

Target

Specifies properties of the target in the solid gauge.

Format Solid Gauge dialog - Target

Use Target Value

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

  • Target Value
    Specifies the target 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.

Format Solid Gauge dialog - Frame

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 specify a new color in the Select Color dialog, 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 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.

Format Solid Gauge dialog - Range Color

Add button

Adds a new color range.

Remove button

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 specify a new color in the Select Color dialog.

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 specify a new color in the Select Color dialog, or input a color string in the format #RRGGBB. If you want to make the background transparent, input Transparent in the text box.

Hint

Specifies properties of the data marker hint.

Format Solid Gauge dialog - 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 platform.

BackPrevious Topic  Next TopicNext

Related articles