MicroStrategy ONE

Axes, Grids and Scales category

Depending on the graph style and axis selected, the Grids and Scales category displays different options. Make the following selections:

Gridlines:

  • Show Major: Displays or hides major grid lines on a numeric axis. Select this check box to show major grid lines and define the following options:

    • Grid Style: Specifies a format or style for major grid lines so that you can easily differentiate them from minor grid lines. Select a grid style from the Grid Style list: Regular Grids, Grids and Ticks, Inner Ticks, Outer Ticks, and Spanning Ticks.

    • Use Manual Grid: Allows you to use a manual number of major grid lines. When you enable drawing of major grid lines, you can have the number of major grid lines automatically calculated or specify a number of major grid lines on a numeric axis. Select this check box to specify a number of major grid lines.

    • Interval Value: Specifies the number of major grid lines based on the interval value. For example, an interval value of 30 in a range of values between 0 and 90 produces three grid lines.

      Note that this also changes the number of value labels displayed on this axis.

  • Show Minor: Displays or hides minor grid lines on the numeric axis. When the check box is selected, minor grid lines are displayed. When the check box is cleared, minor grid lines are not displayed. Minor grid lines are not available for three-dimensional graphs.

    • Grid Style: Specifies a format or style for minor grid lines so that you can easily differentiate them from major grid lines. Select a grid style from the Grid Style list: Regular Grids, Grids and Ticks, Inner Ticks, Outer Ticks, and Spanning Ticks. Minor gridlines are not available for 3D graphs.

    • Use Manual Grid: Allows you to specify a number of minor grid lines between the major grid lines. When you enable the display of minor grid lines, minor grid lines between each major grid line are displayed. Select this check box to specify a number of minor grid lines.

      For Categories axes, this option is named Use manual number of Categories.

    • Count Value for Minor Grid: Specifies the number of minor grid lines displayed between each major grid line. This option is not available for 3D graphs.

      For Categories axes, this option is named Between Gridlines.

  • Disable fractional grid lines: Displays or hides grid lines that are used for fractional interval values on the graph. Fractional values can be displayed on graphs that use a small range of values for one of its axes. Select this check box to hide any interval labels and grid lines for fractional values, which means only grid lines for integer values are displayed. For an example of hiding fractional grid lines, see Displaying or hiding fractional grid lines.

  • Draw Custom Lines at: Allows you to draw a line at the point on the axis you specify. Enter a value for the location of where the line is to be displayed on the axis.

  • Use Logarithmic Scale on This Axis: Uses the logarithmic scale. DO NOT select this check box to use linear scaling on this axis. If the data that defines the numeric axis includes zero or negative values, the application displays an error message. You must choose manual scaling and set minimum and maximum values to greater than zero to choose the logarithmic scale.

  • Always include Zero on This Scale: Includes or excludes a zero on a numeric axis. If you specify a Use Manual Scaling for Minimum Value, this check box is disabled.

  • Off-scale Value Display: Determines how values that are outside the minimum or maximum values specified for a graph will be shown. For steps to change the display of these values and examples of different display options, see Displaying off-scale values in a graph. The display options include:

    • Hide Values: Hides all elements which fall outside of the specified range.

    • Show Values: Displays all elements which fall outside of the specified range. These elements continue off the graph's axes and are only constrained by the size of the graph area.

    • Clip Values: This option shows elements that fall outside the specified range, but forces them to fit into the graph by clipping them to the side.

  • Use Manual Setting: The options listed below allow you to define the maximum and minimum values displayed on an axis.

    If you define a manual maximum and minimum value for a graph axis, the axis is not recalculated when modifying the objects or filtering for a graph. This can cause the axis to not adequately represent the graph data when the data displayed for the graph changes. If the data on a graph changes, you can clear the Maximum Value and Minimum Value check boxes and click Apply to allow the graph to automatically recalculate the size of the axis.

    You should avoid defining manual maximum and minimum values for graphs that are frequently modified such as graphs that use prompts.

    You have the following options:

    • Maximum Value: Allows you to define a specific range of values to be charted regardless of the range of data that is specified in your data sheet. By default, the data in your data sheet is used to determine the range of value labels that is charted on a numeric axis. If you are charting a number of sold widgets, with the smallest number being 53 and the largest number being 934, your Y1 Axis may contain value labels in the range of 50 to 1000.

      When Automatic Scaling is selected, the range of values in the data sheet is used to create the chart. When Manual Scaling is selected, you define only a specific range of values to be charted. If you want to use Manual Scaling for the maximum value, select this check box and for the Maximum Value enter the maximum value to appear on a numeric axis. This value becomes the largest value label on this axis and the graph risers are adjusted accordingly.

    • Minimum Value: Allows you to define a minimum value to be charted. Select the check box, then enter a number for the Minimum Value. This value becomes the smallest value label on this axis and the graph risers are adjusted accordingly.