MicroStrategy ONE

Format: Graph Dialog Box: Axes Tab

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You can format the axes on a graph using the Axes tab in the Format: Graph dialog box. The following options are available:

  • Axes Values and Scales: Determine formatting options for each axis in the graph, as follows:

    • Y1 Axis Values - Use Manual Setting for: By default, options such as the maximum and minimum values displayed on the scale of the Y1-axis are automatically determined. You can override this formatting using the following options:

      • Maximum Value: Select the checkbox and type the maximum value to use on the scale.
      • Minimum Value: Select the checkbox and type the minimum value to use on the scale.
      • Grid Interval: Select the checkbox and type the interval to use between values on the scale.

        When you export a graph report or a document that contains a graph to Excel, type maximum and minimum Y1-axis values as described above to ensure that the exported graph report or document looks exactly the same as it does in Web.

    • Y2 Axis Values - Use Manual Setting for: By default, options such as the maximum and minimum values displayed on the scale of the Y2-axis are automatically determined. You can override this formatting using the following options:

      • Maximum Value: Select the checkbox and type the maximum value to use on the scale.
      • Minimum Value: Select the checkbox and type the minimum value to use on the scale.
      • Grid Interval: Select the checkbox and type the interval to use between values on the scale.
  • Dual Y Options: Determine how series in the graph are assigned to the Y1-axis and Y2-axis, as follows:

    • Assign odd series to Y1 axis and even series to Y2 axis: Select this option to have the odd series on the graph automatically assigned to the Y1-axis, while the even series on the graph are automatically assigned to the Y2-axis. For example, if the 2008 Q1 Revenue Forecast, 2008 Q1 Revenue, 2008 Q2 Revenue Forecast, and 2008 Q2 Revenue series appear on your graph report, 2008 Q1 Revenue Forecast and 2008 Q2 Revenue Forecast are assigned to the Y1-axis, while 2008 Q1 Revenue and 2008 Q2 Revenue are assigned to the Y2-axis.
    • Manually assign series to each axis: Choose this option to manually select the axis on which to display each series. For each series you want to display on a specific axis, select the name of the series. To display the series on the Y2-axis, click the Add icon Add icon. To display the series on the Y1-axis, click the Remove icon Remove icon.

Related Topics

Format: Graph Dialog Box: General Tab

Format: Graph Dialog Box: Format Tab

Format: Graph Dialog Box: Number Tab

Format: Graph Dialog Box: Advanced Tab

Format: Graph Dialog Box: Options Tab