Page History
The mekko chart, also known as Marimekko, utilizes a 100% stacked bar along with varying widths to capture two variables in a single visualization.
Info |
---|
Download and connect to the sample data source. We are making this chart using 2 dimensions and 1 measure. |
...
To build a Mekko Chart
- Connect to the sample data source in Aqua Data Studio.
- From the Dimensions pane, select Coffee and Geography.
- From the Measures pane, select Profit.
Mekko Chart only supports Sum and Count aggregate functions for Measures. - Click the the tab and then click . Visualization builds a Mekko Chart.
Visualization builds a Mekko Chart. The first dimension that Visualization places in the Break Deck make the X-axis and Measure forms the Y-axis. The second dimension goes to the Color Deck and is represented as a stack column. Any other selected dimension is placed in the Break Deck and divides the stack further. You can rearrange the dimensions in the Break Deck, to change the order of grouping on the chart. In the following example, Coffee forms the X-axis, Geography draws the stacked columns for each coffee brand based on different colors, and Profit forms the Y-axis and displays percentage.
Show Column Total
...
- In the Chart Properties area, click the Label Deck.
- Select the Show Column total check box. The coffee profits for each city appears appear on top of each column.
Show Column Percentage
...
- In the Chart Properties area, click the Label Deck.
- Select the Show Column percentage check box. The coffee profits for each city appears as a percentage value on top of each column.
Show Measure Percentage
...
- In the Chart Properties area, click the Label Deck.
- Select the Show Measure percentage check box. The profit for each city appears as a percentage value in each cell.
Include Negative Values
...
- In the Chart Properties area, click the Options Deck.
- Click the Use absolute values option. As Visual Analytics changes all negative values into absolute values, the total profit for coffee appears more as compared to when Visualization ignored negative values.
Other Actions
Other actions that you can perform on a plotted mekko chart are as follows:
...