Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am an intermediate excel user struggling to create a specific chart for an internship project. I have spent a lot of time trying to figure it out and have searched the web extensively.

Below is an example chart with example data:

Example Chart

share|improve this question
up vote 9 down vote accepted

What you describe is a Marimekko chart, or variable width column chart. They can be created in Excel using the Area chart and a well-organised data layout.

Excel MVP and charting guru Jon Peltier has a step by step tutorial here:

Edit: The screenshot shows your data, the data layout required (truncated) and the final chart.

enter image description here

Create a data table as in columns F to H in the screenshot, insert an Area chart for that data, with column F as the X axis. Change the X axis from category to time axis. Use the label helper table to add a data series, send it to the secondary axis, make it a line chart, use a date axis. Use the free XY Chart Labeler add-in to place the labels below the data markers of the line. Hide the line, data markers and unwanted axes lines and labels.


Download file.

share|improve this answer
Cascade charts are similar in construction to Marimekko charts. See Variable Width Column Charts (Cascade Charts). – Jon Peltier Jan 13 at 14:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.