Mini Excel for Data Charts

To illustrate a numerical value depending on at least two dimensions, Mekko charts are particularly suitable.

A distinction is made between two variants.

The Marimekko chart is to be understood as a two-axis stacked bar chart in which both axes represent 100% (Figure 672, “Marimekko Chart”).

The column Mekko chart, on the other hand is to be understood as a two-axis stacked bar chart, in which, however, the axes do not represent 100% in contrast to the Marimekko (Figure 673, “Column Mekko Chart”).

The mini Excel for Mekko charts contains a special row which is not included in mini Excels for other data charts.

The row Width in Mekko charts is used for the sum of all data points in a series (Figure 674, “Mekko Chart Mini Excel”).

It contains a formula and is therefore calculated automatically.

Therefore, do not edit this row manually.

In column Mekko charts, negative values are supported.

Here, it is important that you enter negative values in the series that you want to achieve the desired shape of the chart for.

The chart can then be optimized using breaks.

The mini Excel for waterfall charts contains sum columns.

These sum columns are used to calculate the total sum of either all series or one series.

The columns are named Total N. To indicate a sum column, set the value of one or more series to x for this column (Figure 675, “Waterfall Chart Mini Excel”).

If only one series value is set to x, the overall sum over all series is calculated.

If two or more series values are set to x, the per series sums are calculated and displayed.

The column itself does not contain a formula. However, the sums are calculated automatically and displayed in the chart accordingly.

If any row of a column contains the keyword <new>, a new waterfall starts with the upcoming column. The columns used to indicate the start of a new waterfall are named SpalteN.

Sum columns are calculated separately for each new waterfall.

You may configure the starting value for the new waterfall by defining it after <new>.

For example, you would then enter <new>500 into the cell (Figure 675, “Waterfall Chart Mini Excel”).

The mini Excel for bubble and scatter charts contains an additional column.

This column is named Group/Series.

For scatter and bubble charts, the series assignment of the points takes place via this column. You can use this column and similar entries to reach a grouping of their data points (Figure 676, “Scatter Chart Mini Excel”).

This gives you the opportunity to differentiate the groupings in terms of color and legend.

Butterfly charts can be created from stacked column charts (Figure 677, “Butterfly Chart”).

To do so, insert a stacked column chart and edit its mini Excel.

To display the contrast in a butterfly chart, it is important that you enter only negative values for the series that is supposed to be displayed on the left-hand side (Figure 676, “Scatter Chart Mini Excel”).

Then, disable the column sums via the button Data Labels in the action bar and set the number format for data labels to Value.