Before You Begin

This tutorial shows you how to create a 100% stacked bar chart and change it into a Mekko chart in Oracle Analytics.

Background

A Mekko chart, also known as a mosaic or Marimekko chart, represents multiple dimensions with a size value. To change a bar chart into a Mekko chart, you reduce the gap between bars to zero. The varied size of the segments in the Mekko chart enable evaluating the impactful segments from those with less impact.

A thin line separates the rectangular segments of the Mekko chart. You can add data labels that provide the percentage, value, and data element involved in each segment.

You can create a Mekko chart from the other bar visualization types available in Oracle Analytics.

Time dimensions aren't supported as the size dimension in Oracle Analytics.

What Do You Need?

Create a Dataset

In this section, you create a dataset to use for creating visualizations.

  1. Sign in to Oracle Analytics.
  2. On your home page, click Create, and then select Dataset.
  3. In Create Dataset, click Drop data file here or click to browse, select the sample_order_lines2023.xlsx file, and then click Open.
  4. In Create Dataset Table from sample_order_lines2023.xlsx, click OK.


    Description of sample_order_lines2023_jd.png follows
    Description of the illustration sample_order_lines2023_jd.png
  5. Click Save Save icon. In Save Dataset As, enter sample_order_lines2023, and then click OK.

Create a Stacked Bar

In this section, you create a stacked bar chart in preparation for creating a Mekko chart.

  1. Click Create Workbook.
  2. In the Data pane, hold down the Ctrl key, select Sales, Product Category, and Ship Mode.
  3. Right-click, select Pick Visualization, and then select 100% Stacked Bar 100% Stacked Bar icon.


    Description of 100percent_stacked_bar.png follows
    Description of the illustration 100percent_stacked_bar.png
  4. In the Data pane, drag Shipping Cost to Size (Width) in the Grammar pane.


    Description of shipping_cost.png follows
    Description of the illustration shipping_cost.png
  5. Click Save Save icon. In Save Workbook, enter Mekko Chart in Name and click Save.

Update the Visualization's Properties

In this section, you update the visualization properties of the 100% stacked bar chart to change it into a Mekko chart.

  1. Click Properties Properties icon. On the General Properties General tab icon tab, in the Bar Gap row, click 37 and move the slider to zero.


    Description of bar_gap_zero.png follows
    Description of the illustration bar_gap_zero.png
  2. In the Bar Size row, click Apply to Segments and select Apply to Stack.


    Description of mekko_chart.png follows
    Description of the illustration mekko_chart.png
  3. In Properties, click Values Properties Values tab icon. Under Sales, click Off in the Data Labels Position and select Top.
  4. In the Data Labels row, click Percent and click Value.
  5. In the Data Labels Font row, click Auto and click Data Label Font data_label_font_icon.
  6. In Data Label Font, click #f4f3c5, the pale yellow color, and click OK.


    Description of mekko_data_labels.png follows
    Description of the illustration mekko_data_labels.png
  7. Click Save Save icon.

Change the Data Elements in the Mekko Chart

In this section, you change the data elements in the Mekko chart.

  1. In the Data pane, drag Customer Segment to Color in the Grammar panel to replace Ship Mode.
  2. In the Data pane, drag Quantity Order to Size (Width) in the Grammar panel to replace Shipping Cost.


    Description of cust_seg_sales.png follows
    Description of the illustration cust_seg_sales.png

Learn More