Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The mekko chart, also known as Marimekko, utilizes a 100% stacked bar along with varying widths to capture two variables in a single visualization.

Image RemovedImage Added

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 Image Removed the Image Added tab and then click Image Removed Image Added. Visualization builds a Mekko Chart.
    Image RemovedImage Added
    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.

Image RemovedImage Added 

Show Column Total

...

  1. In the Chart Properties area, click the Label Deck.
  2. Select the Show Column total check box. The coffee profits for each city appears appear on top of each column.
    Image RemovedImage Added

Show Column Percentage

...

  1. In the Chart Properties area, click the Label Deck. 
  2. Select the Show Column percentage check box. The coffee profits for each city appears as a percentage value on top of each column.
    Image RemovedImage Added

Show Measure Percentage

...

  1. In the Chart Properties area, click the Label Deck. 
  2. Select the Show Measure percentage check box. The profit for each city appears as a percentage value in each cell.
    Image RemovedImage Added

Include Negative Values

...

  1. In the Chart Properties area, click the Options Deck. 
  2. 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.
    Image RemovedImage Added

Other Actions

Other actions that you can perform on a plotted mekko chart are as follows:

...