Mekko Chart Properties

Dimensions

Choose dimensions in the drop-down list. To add a dimension, click . Select a dimension in the drop-down. Use the icon to move items in the list. The icon removes items from the list. For more settings, click the More... button.

Dimension

Enable Conditional

Marking this check box hides or shows the dimension dynamically, depending on the value of a condition expression entered, by clicking the button in the edit box below.

Dimension

Displays the currently selected dimension.

Show Label

Mark this check box to show a dimension label (the field name) on the x-axis.

Suppress Null Values

If this check box is marked, the field selected as Dimension above will not be displayed in the chart if its value is NULL.

Show All Values

Mark this check box to show all the dimension field values in the chart, including logically excluded values.

Show Axis Labels

Mark this check box to show legend (names of field values) on the x-axis for the selected dimension field.

Limit Axis Label Characters

Mark this check box to limit the length of the dimension value strings to be shown on axes and in the chart legend. Specify the number of characters in the input field, or drag the slider to the desired value. Truncated values will be followed by ... in the chart. This option can be used independently to the other options in this group.

Trellis Setting First Dimension

Marking this check box will enable the trellis chart, where an array of charts that are based on the chart's first dimension are displayed.

Fixed Number of Columns

Enter the number of columns you want the trellis chart to display. Specify the number of columns in the input field, or drag the slider to the desired value.

Fixed Number of Rows

Enter the number of rows you want the trellis chart to display. Specify the number of rows in the input field, or drag the slider to the desired value.

Second Dimension

Enables the second dimension in the trellis chart. If a secondary dimension is used, the first dimension values will be displayed as columns in the trellis matrix, whereas the secondary dimension values will be displayed as rows in the trellis matrix.

Sort


Sets the sort order of the values in the sheet object. Some sort options may not be available for all sheet objects.
If more than one sort order is specified, the sort order will be state, expression, frequency, numeric, text, load order. State refers to the logical state (selected, optional, or excluded).

Primary Sort

Y-Value
Sets whether the dimension values should be sorted according to the numeric value of the y-axis. This option is not available for calculated dimensions.
Frequency
Sorts the field values by frequency (number of concurrences in the table).
Numeric Value
Sorts the field values by their numeric values.
Text
Sorts the field values in alphabetical order.
Load Order
Sorts the field values by the initial load order.

Secondary Sort

Frequency
Sorts the field values by frequency (number of concurrences in the table).
Numeric Value
Sorts the field values by their numeric values.
Text
Sorts the field values in alphabetical order.
Load Order
Sorts the field values by the initial load order.

Sort by Expression

Sorts the field values according to the expression entered. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Keep Selected on Top

Enable this to keep the selected values on top.

Limits

Restrict which values are displayed using the first expression

These properties are used to determine how many dimension values are displayed in the chart, according to settings made below.

Show only

Select this option if you want to show the First, Largest or Smallest x number of values. If this option is set to 5, there will be five values displayed. If the dimension has Show Others enabled, the Others segment will take up one of the five display slots.

The First option will return the rows based on the options selected on the Sort tab of the property dialog. If the chart is a Straight Table, the rows will be returned based on the primary sort at the time. In other words, a user can change the values display by double-clicking on any column header and making that column the primary sort.

The Largest option returns the rows in descending order based on the first expression in the chart. When used in a Straight Table, the dimension values shown will remain consistent while interactively sorting the expressions. The dimensions values will (may) change when the order of the expressions is changed.

The Smallest option returns the rows in ascending order based on the first expression in the chart. When used in a Straight Table, the dimension values shown will remain consistent while interactively sorting the expressions. The dimensions values will (may) change when the order of the expressions is changed.

Enter the number of values to display. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.
Select Include Boundary Values to include the dimension value that contains the comparison value.

Show only values that are:

Select this option to display all dimensions values that meet the specified condition for this option. Select to display values based on a percentage of the total, or on an exact amount. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Show only values that accumulate to:

When this option is selected,all rows up to the current row are accumulated, and the result is compared to the value set in the option. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog, and compares the accumulated values (based on first, largest or smallest values) to the overall total. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Show Others

Enabling this option will produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart.

Label
Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart.

Show Total

The chart will display a total for the selected dimension when this option is enabled. This total behaves differently than the expression total, which is still configured on the Expressions tab of the property dialog.

Label
Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Use Global Grouping Mode

The option only applies to inner dimensions. When this option is enabled the restrictions will be calculated on the selected dimension only. All previous dimensions will be ignored. If this is disabled, the restrictions are calculated based on all preceding dimensions.

Axis

Show Axis

Check this box to show the axis.

Axis Width

Enter the width of the axis and its tick marks, or drag the slider to the desired value.

Major Label

Select Horizontal, Vertical or Tilted display of the major labels.

Minor Label

Select Horizontal, Vertical or Tilted display of the minor labels.

Show Grid

Check this box to show a grid in the chart originating from the tick marks of the x-axis. The grid lines can be formatted using the Grid Style and Grid Color settings.

Show Minor Grid

Check this box to show minor lines in-between the grid lines. Only available if Show Grid is selected. The grid lines can be formatted using the Grid Style and Grid Color settings.

Stagger Labels

Select this option to stagger x-axis labels when they become to many to show side by side.

Reverse Stagger

X-axis labels are normally staggered bottom-up from left to right. When marking this check box, the stagger will be reversed to top-down.

Continuous X

Sets the x-axis to be continuous, i.e. it will be interpreted numerically and shown with numerically correct intervals.

Force 0

Fixes the lower edge of the chart to zero on the y-axis. This option is not available when a logarithmic axis is used.

Static Min

Sets a fixed minimum value for the axis. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Static Max

Sets a fixed maximum value for the axis. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Static Step

Sets a fixed interval for tick marks on the axis. If this setting results in more than 100 tick marks, the value used will be modified. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Backcast

By entering an integer in the edit field, you force the x-axis to be extended to the left of the actual data points plotted. This is useful when using trend lines. The backcast line will be dotted. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Forecast

By entering an integer in the edit field, you force the x-axis to be extended to the right of the actual data points plotted. This is useful when using trendlines. The forecast line will be dotted. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Expressions

Choose expressions in the drop-down list. To add an expression, click . Select an expression from the drop-down. Use the icon to move items in the list. The icon removes items from the list. For more information click the More... button.

Expression

Enable

Marking this check box will enable the selected expression. If the box is not marked, the expression will not be used at all.

Conditional

Marking this check box hides or shows the expression dynamically, depending on the value of a condition expression entered, by clicking the button in the edit box below.

Label

The label of the expression. Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Expression

Displays the currently selected expression.

Comment

Enter a comment to describe the purpose and function of the expression. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Invisible

Hides the expression.

Show in Percent (Relative)

The chart shows the result in percent instead of absolute numbers.

Accumulate Expression

Check this box to accumulate expressions. Click to open the popup.

Show in Legend

When several expressions are used, this option displays a legend showing the expressions and their corresponding colors next to the chart.

Value Display Settings

Check this box to define how to display values. Click to open the popup.

Attribute Expression Styles

Background Color
Define an attribute expression for calculating the basic plot color of the data point. The expression used should return a valid color representation (a number representing the Red, Green and Blue components as defined in Visual Basic) which is typically achieved by using one of the special chart color functions. If the result of the expression is not a valid color representation, black will be used.

Axis

Show Axis

Check this box to show the axis.

Axis Width

Enter the width of the axis and its tick marks, or drag the slider to the desired value.

Split Axis

Check this box to split the y-axis into two parts, thus creating an impression of two charts sharing a common x-axis.

Position

Choose Left or Right position.

Show Grid

Check this box to show a grid in the chart originating from the tick marks of the x-axis. The grid lines can be formatted using the Grid Style and Grid Color settings.

Show Minor Grid

Check this box to show minor lines in-between the grid lines. Only available if Show Grid is selected. The grid lines can be formatted using the Grid Style and Grid Color settings.

Log Scale

If this box is checked, the scale will be logarithmic.

Force 0

Fixes the lower edge of the chart to zero on the y-axis. This option is not available when a logarithmic axis is used.

Static Min

Sets a fixed minimum value for the axis. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Static Max

Sets a fixed maximum value for the axis. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Static Step

Sets a fixed interval for tick marks on the axis. If this setting results in more than 100 tick marks, the value used will be modified. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Static Center

Sets a fixed value on the axis which will be positioned in the center of the plot area. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

 
Show Title By default, the label of the first expression defined is set as chart title. Clear the check box if you do not wish to have a chart title. The title may be defined as a calculated formula for dynamic update. Click to open the Edit Expression dialog.
More.../Less... Click this button to expand/collapse the foldout that contains additional tabs. Depending on if the Dimensions or Expressions field is active, different tabs are displayed.