Axis

42 posts
This Excel chart looks standard but gets everything wrong

The following CNBC chart (link) shows the trend of global car sales by region (or so we think). This type of chart is quite common in finance/business circles, and has the fingerprint of Excel. After examining it, I nominate it for the Hall of Shame. *** The chart has three major components vying for our attention: (1) the stacked columns, (2) the yellow line, and (3) the big red dashed...

0 0
This chart tells you how rich is rich – if you can read it

Via twitter, John B. sent me the following YouGov chart (link) that he finds difficult to read: The title is clear enough: the higher your income, the higher you set the bar. When one then moves from the title to the chart, one gets misdirected. The horizontal axis shows pound values, so the axis naturally maps to "the higher your income". But it doesn't. Those pound values are the "cutoff"...

0 0
How to read this cost-benefit chart, and why it is so confusing

Long-time reader Antonio R. found today's chart hard to follow, and he isn't alone. It took two of us multiple emails and some Web searching before we think we "got it".   Antonio first encountered the chart in a book review (link) of Hal Harvey et. al, Designing Climate Solutions. It addresses the general topic of costs and benefits of various programs to abate CO2 emissions. The reviewer praised the...

0 0
The rule governing which variable to put on which axis, served a la mode

When making a scatter plot, the two variables should not be placed arbitrarily. There is a rule governing this: the outcome variable should be shown on the vertical axis (also called y-axis), and the explanatory variable on the horizontal (or x-) axis. This chart from the archives of the Economist has this reversed: The title of the accompanying article is "Ice Cream and IQ"... In a Trifecta Checkup (link), it's...

0 0
Too much of a good thing

Several of us discussed this data visualization over twitter last week. The dataviz by Aero Data Lab is called “A Bird’s Eye View of Pharmaceutical Research and Development”. There is a separate discussion on STAT News. Here is the top section of the chart: We faced a number of hurdles in understanding this chart as there is so much going on. The size of the shapes is perhaps the first...

0 0
Wayward legend takes sides in a chart of two sides, plus data woes

Reader Chris P. submitted the following graph, found on Axios: From a Trifecta Checkup perspective, the chart has a clear question: are consumers getting what they wanted to read in the news they are reading? Nevertheless, the chart is a visual mess, and the underlying data analytics fail to convince. So, it’s a Type DV chart. (See this overview of the Trifecta Checkup for the taxonomy.) *** The designer did...

0 0
Clarifying comparisons in censored cohort data: UK housing affordability

If you're pondering over the following chart for five minutes or more, don't be ashamed. I took longer than that. The chart accompanied a Financial Times article about inter-generational fairness in the U.K. To cut to the chase, a recently released study found that younger generations are spending substantially higher proportions of their incomes to pay for housing costs. The FT article is here (behind paywall). FT actually slightly modified...

0 0
Clarifying comparisons in censored cohort data: UK housing affordability

If you're pondering over the following chart for five minutes or more, don't be ashamed. I took longer than that. The chart accompanied a Financial Times article about inter-generational fairness in the U.K. To cut to the chase, a recently released study found that younger generations are spending substantially higher proportions of their incomes to pay for housing costs. The FT article is here (behind paywall). FT actually slightly modified...

0 0
Re-thinking a standard business chart of stock purchases and sales

Here is a typical business chart. A possible story here: institutional investors are generally buying AMD stock, except in Q3 2018. Let's give this chart a three-step treatment. STEP 1: The Basics Remove the data labels, which stand sideways awkwardly, and are redundant given the axis labels. If the audience includes people who want to take the underlying data, then supply a separate data table. It's easier to copy and...

0 0
Re-thinking a standard business chart of stock purchases and sales

Here is a typical business chart. A possible story here: institutional investors are generally buying AMD stock, except in Q3 2018. Let's give this chart a three-step treatment. STEP 1: The Basics Remove the data labels, which stand sideways awkwardly, and are redundant given the axis labels. If the audience includes people who want to take the underlying data, then supply a separate data table. It's easier to copy and...

0 0