« Redundancy | Main | Feast for the eyes? »

Comments

Jack

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.

Jack

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?

Kaiser

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.

The comments to this entry are closed.

BOOTCAMP SUMMER '19



Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog



Link to junkcharts

Graphics design by Amanda Lee

The Read



Keep in Touch

follow me on Twitter

Residues