Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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:

http://peltiertech.com/WordPress/marimekko-charts/

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.

Done.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .