Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 5 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

Your Answer

 
discard

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.