How to add separators to the Marimekko chart

Excel 2016
This is the second part of the tip How to create a Marimekko or Mekko chart in Excel. In the first part of this tip, a step Area chart was created:
The new step Area chart for Marimekko in Excel 365

Horizontal separators

To add horizontal separators (lines) to the chart, do the following:

   1.   Right-click on the data series and choose Format Data Series... in the popup menu:

Format data series in popup menu Excel 365

   2.   On the Format Data Series pane, on the Fill & Line tab, in the Border section, select the Solid line option and choose the color and width in the appropriate fields:

Format Data Series line in Excel 365

   3.   Repeat previous steps for all data series in the chart:

The horizontal lines in Marimekko chart Excel 365

Vertical separators

To add vertical separators (lines), do the following:

Note: Instead of the following steps, you can add the new data series for the vertical lines and format them (see How to add a vertical line to the chart).

   4.   Select the chart.

   5.   On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element dropdown list:

Add Chart Element button in Excel 365

In the Add Chart Element dropdown list, select the Lines list and then Drop Lines:

Add Drop Lines button in Excel 365

   6.   Right-click on any of the drop lines and choose Format Drop Lines... in the popup menu:

Format Drop Lines in Excel 365

   7.   On the Format Drop Lines pane, on the Fill & Line tab, in the Line section, select the Solid line option and choose the color and width in the appropriate fields (repeat the same color and width as for the data series borders):

Format Drop Lines pane in Excel 365

The mosaic part is done:

The Marimekko chart with separators in Excel 365

To add labels to the chart, see the last part of this tip How to add labels to the Marimekko chart in Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.