A user recently asked us how to make a chart comparing the size of different financial asset types and then coloring the chart based on a secondary variable, flow by asset type (colors moving from dark green as the most positive and dark red as the most negative).
Here’s the marimekko chart that we created:
First, we had to categorize the assets into segments to create the marimekko. We chose 3 segments-domestic, global and all other.
Here’s the data in the Excel spreadsheet:
We created the cell colors used Excel’s Color Scales (under Conditional Formatting) by selecting just the data in the Flow column. We wanted to apply that coloring to the 3 columns of asset size data that will be used in the marimekko. To do that, we copied the Flow column and pasted it into Word to remove the conditional format. Then we copied the data from Word and pasted it back into the new column in the spreadsheet, Format Only. We copied that column and used Paste Special Formats to apply the colors to the 3 asset size columns.
Next, we copied our data from the Excel spreadsheet and pasted it into the Mekko Graphics data editor. To use the colors from the data sheet on the chart, we selected “Apply Cell Colors from Spreadsheet” in the Format Chart task pane under the Style tab.