« Redundancy | Main | Feast for the eyes? »



Can you make a BUMPS chart in Excel? I can come close using a line chart, but it doesn't look as good and takes a bit of work.


Did you see the Economist ran the same data in a bar chart this week. I thought it was informative (and not entertaining). What did you think?


I have made Bumps charts in Excel. The trick is to click on the X-axis and *not* to have Y values "cross between categories". The effect is to squeeze out the redundant space on either side of the graph.

However, it is difficult to get the data labels exactly right. It is particularly hard for multi-period Bumps chart because the data label function does not seem to recognize the presence of a 3rd dimension.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter