How To Use Marimekko Charts To Show Percentage Changes Over Time

A Marimekko chart is a graphical tool that can show percentage changes over time. The chart can be customized to show different data points and can be used to compare data sets. Marimekko charts are a great way to visualize percentage changes over time. They can show how a particular metric has changed over time or compare multiple metrics side-by-side. Keep reading to learn how to use a Marimekko chart to show percentage changes over time.

What is a Mekko Chart?

A Marimekko chart, also known as a Mekko chart, is an advanced column chart used to display percentage changes over time. It's similar to a stacked column chart, but the columns are divided into segments of different widths instead of heights. This allows you to compare the relative sizes of each segment more easily. It can show percentage changes, absolute changes, or both.

How do you create a Marimekko chart in excel?

Creating a Marimekko chart is a great way to show percentage changes over time. To create a Marimekko chart in Excel, you will need two data series, one for the percentage change and one for the period.

• Select the data for the percentage change.

• In the Insert tab, select Bar Chart.

• Select the clustered bar chart.

• Select the Switch Row/Column button in the Chart Tools Design tab.

• Select the percentage change data series and press the up arrow key to move it to the column chart.

• Select the period data series and press the down arrow key to move it to the row chart.

• In the Chart Tools Layout tab, select the More Options button.

• Select the Series Overlap button and select the 100% option.

• Select the Legend and enter a legend.

• Select the Data Labels and check the Show Value option.

• Select the Gridlines and check the Show Major Gridlines and Show Minor Gridlines options.

• Select the Chart Colors and choose the colors you want.

• Select the Save as Type and save the chart as a PDF.

Format your axes to show percentage changes.

The axes in a Marimekko chart can show percentage changes over time. When calculating percentage changes over time, it's important to remember that the original value is always the value at the beginning of the time being considered. If you want to calculate the percentage change between two numbers for a specific time period, you would need to use the same starting point for both numbers. To format the axes, follow these steps:

Select the axis you want to format, then click on the Format Axis button in the toolbar. Next, select Percentage from the Unit drop-down list in the Format Axis pane. From there, enter 100 into the Minimum and Maximum text boxes.

Add your title and labels to your Mekko Chart.

(Photo : Campaign Creators on Unsplashj)

Adding titles and labels to your Marimekko chart is a great way to make it more informative and visually appealing. Titles can help you identify what each section of the chart represents, while labels give you more information about the data points.

To add a title, click on the text box in the top left corner of your chart and enter your desired title. To add labels, click on any data point in your chart and then type your desired label into the text box that appears. You can also change the font, size, and color of both titles and labels by clicking on the corresponding buttons at the top of the screen.

Marimekko charts are an important tool to show percentage changes over time. They can be used to visualize how a certain value changes or to compare the performance of two or more items. Overall, they are an effective way to communicate changes in data.