MicroStrategy ONE

Labels and Values for series

Depending on the graph style, the Labels and Values category displays different options. Make the following selections:

  • Show Data Labels: Displays or hides data labels in a graph. Data labels are the actual values from the cells in your data sheet. When you enable the display of data labels (for all risers/markers or for an individual series), the values from the data sheet are displayed at a selected location on or near the risers/markers in the graph.

  • Labels Location: Specifies where the data labels should be displayed next to their associated risers in the graph. The options are Outside Maximum, Inside Maximum, Center, and Base of Chart. For Bubble charts, the options are Markers Above Text, Markers Below Text, Text Centered on Marker, Markers to Left of Text, and Markers to Right of Text.

  • Label Format: Allows you to choose Value, Label, or Label & Value.

  • Value: Displays the values from the data sheet at the corresponding location on each riser.

  • Label: Displays the series labels.

  • Label & Value: Displays the series labels and the value from the data sheet.

For Bubble charts, you have the following Label Format options:

  • (X,Y) Value: Displays the first two values (X and Y position) that define each data point for each bubble marker.

  • (X,Y, Bubble Size): Displays the first two values (X and Y positions) that define each data point for each Bubble marker. The value representing the size of the Bubble (diameter) is also drawn next to the X and Y values.

  • Bubble Size: Displays the value representing the size of the Bubble (diameter) for each Bubble marker.

  • Label: Displays the series label.

  • (X, Y) Value and Label: Displays the first two values (X and Y position) that define each data point for each bubble marker and displays the series label.

  • XY, Bubble Size and Label: Displays the value representing the size of the Bubble (diameter) for each Bubble marker and displays the series label.

  • Bubble Size and Label: Displays the value representing the size of the Bubble (diameter) for each Bubble marker and displays the series label.

For Stock graphs, you have the following Label Format options:

A Stock graph can only show one of the following labels on a graph. If you view a Stock graph using MicroStrategy Web, you can include the other labels by displaying tooltips on the graph, as described with the Show Tooltip option below.

  • Open: Displays the value representing an element's value when it is first recorded. For example, for a daily stock price, the open value represents the price of the stock at the beginning of the day, just as the stock market opens. This value is retrieved from the third metric in the series of the graph for Hi-Lo-Open and Hi-Lo-Open-Close Stock graphs.

  • Close: Displays the value representing an element's value when it is last recorded. For example, for a daily stock price, the close value represents the price of the stock when the stock market officially closes for the day. This value is retrieved from the fourth metric in the series of the graph for Hi-Lo-Open-Close Stock graphs.

  • High: Displays the value representing the highest value achieved during a certain period of time. For example, for a daily stock price, the high value represents the highest price the stock reached for the day. This value is retrieved from the first metric in the series of the graph for Hi-Lo, Hi-Lo-Open, and Hi-Lo-Open-Close Stock graphs.

  • Low: Displays the value representing the lowest value achieved during a certain period of time. For example, for a daily stock price, the low value represents the lowest price the stock reached for the day. This value is retrieved from the second metric in the series of the graph for Hi-Lo, Hi-Lo-Open, and Hi-Lo-Open-Close Stock graphs.

  • Show Data Labels Lines: Displays a line from the center of the bubble to the label for each bubble marker of a Bubble chart.

  • Show Value as Percentage: Displays the percentage value that each riser represents if you selected a Label Format of Value or Value and Label in a Percent graph.

  • Cumulative Values: Displays the cumulative value of each riser if you select a Label Format of Value or Value and Label in a Percent or Stacked graph.

  • Absolute Values: Displays the absolute value of each riser if you selected a Label Format of Value or Value and Label in a Percent or Stacked graph.

  • Show Total: Displays the total value of each category of risers. Select AbsoluteValues check box to enable the Show Total check box.

  • Show Tooltip (Web Only): Tooltips are text that is displayed when a user passes the cursor over a graph's series in MicroStrategy Web. The contents of tooltips can be changed by using macros, dynamic text that is replaced with graph information when a tooltip is shown. To display a tooltip in MicroStrategy Web, select the Show Tooltip (Web Only) check box. This also allows you to modify the tooltip. In the pane below, enter the macro that displays the desired tooltip information or your own static text. A table of tooltip macros is shown below:
     

    Macro

    Information Displayed

    {&TOOLTIP}

    All relevant labels and values associated with a graph item.

    {&GROUPLABEL}

    Name of the graph item's category. This value is often the graph item's attribute element information, as attributes are commonly used as the categories of graph reports.

    {&SERIESLABEL}

    Name of the graph item's series. This value is often the graph item's metric name information, as metrics are commonly used as the series of graph reports.

    {&VALUE}

    The value of a given data point.

    {&XVALUE}

    The X-value of a data point. Only applicable to Bubble charts and Scatter plots.

    {&YVALUE}

    The Y-value of a data point. Only applicable to Bubble charts and Scatter plots.

    {&ZVALUE}

    The Z-value of a data point. Only applicable to Bubble charts and Scatter plots.

    {&XLABEL}

    The label of the X-axis. Only applicable to Bubble charts and Scatter plots.

    {&YLABEL}

    The label of the Y-axis. Only applicable to Bubble charts and Scatter plots.

    {&ZLABEL}

    The label of the Z-axis. Only applicable to Bubble charts and Scatter plots.

Pie and Funnel graphs

For Pie and Funnel graphs, you have additional options, as explained below:

  • Use "Smart" Label Placement: Adjusts the graph so that labels are spread out to better accommodate for the size of the graph.

  • Show Values: Displays or hides data label values for each slice in the pie or funnel graph.

  • Show Values as Percentage: If Show Values is selected, shows the data values as a percentage of the total. Do not select this check box to show the absolute value that defines each slice.

  • Values on Slices: If Show Values is selected, displays the data values on each slice.

  • Values outside Slices: If Show Values is selected, select the option to display the data values outside each slice.

  • Show Pie Total: In Ring Pie graphs, displays the total value in the center of each pie. If you select this check box, you can also format the font, fill , and border formatting of the total values.

  • Show Labels: Displays or hides the series label associated with each slice.

  • Labels on Slices: If Show Labels is selected, displays the series labels on each slice.

  • Labels outside Slices: If Show Labels is selected, displays the series labels outside each slice.

  • Show Leader Lines: If Values outside Slices is selected, displays leader lines from each slice to the data value and/or series label displayed next to it.

  • Labels on Sides: If Values outside Slices is selected, aligns the data labels to the left of the graph.

Related Topics