By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Recreating Another New York Times Chart
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > Recreating Another New York Times Chart
Uncategorized

Recreating Another New York Times Chart

JuiceAnalytics
Last updated: 2009/07/26 at 8:41 PM
JuiceAnalytics
4 Min Read
SHARE

At the recent Turning Statistics into Knowledge conference (here’s a synopsis), I saw The New York Times’ Amanda Cox present on how their 25-person design team designs and builds infographics. In my opinion, The New York Times sets the bar for telling stories with data. Amanda, I later found out, is sometimes referred to as the Michael Phelps of Infographics — presumably for her tendency to win infographics awards, not for getting photographed with a bong.

Here’s a infographic from the presentation that I particularly liked:

Turning a corner

This chart is a re-examination of the OECD Business Cycle Clock which:

More Read

AI takeover life

Are Fears of AI’s Takeover Exaggerated?

Things You Might Not Know About Big Data [INFOGRAPHIC]
Big Data Ethics and Your Privacy [INFOGRAPHIC]
Celebrating the Philae Landing [INFOGRAPHIC]
7 Ways Big Data Could Revolutionize Our Lives by 2020 [INFOGRAPHIC]

has been designed to better visualize business cycles – fluctuations of economic activity around their long term potential level – and how some key economic indicators interact with the business cycle.

(Flowing Data also took a look at this chart and the other approaches to presenting the same data.)

Amanda’s version of this chart is great because it demonstrates what can be done with the under-used scatterplot chart. Scatterplots are effective at presenting the relative performance of a set of things (e.g., product portfolio). Typically they show a …

At the recent Turning Statistics into Knowledge conference (here’s a synopsis), I saw The New York Times’ Amanda Cox present on how their 25-person design team designs and builds infographics. In my opinion, The New York Times sets the bar for telling stories with data. Amanda, I later found out, is sometimes referred to as the Michael Phelps of Infographics — presumably for her tendency to win infographics awards, not for getting photographed with a bong.

Here’s a infographic from the presentation that I particularly liked:

Turning a corner

This chart is a re-examination of the OECD Business Cycle Clock which:

has been designed to better visualize business cycles – fluctuations of economic activity around their long term potential level – and how some key economic indicators interact with the business cycle.

(Flowing Data also took a look at this chart and the other approaches to presenting the same data.)

Amanda’s version of this chart is great because it demonstrates what can be done with the under-used scatterplot chart. Scatterplots are effective at presenting the relative performance of a set of things (e.g., product portfolio). Typically they show a snapshot in time; Amanda has added a time dimension without visually overwhelming the user.

As we’ve done in the past, we wanted to try to recreate a New York Times-style graphic in Excel. Here’s how it came out:

Business Cycle

We have a few tricks in here to make this Excel chart possible:

  • The chart is a scatterplot with smoothed connector lines. A second highlight series displays just values based on the time selection at the top.
  • The line chart at the bottom contains a bar chart that keys off of the time selector to help visually display the time range selected.
  • All the labels on the chart are extra data series with data labels rather than adding text labels onto the chart. This approach makes it easier to place the points in the appropriate spot and not worry about problems on resizing.
  • A simple macro on the “animate” button walks through the data.

You can download the Excel spreadsheet here

 Link to original post

TAGGED: amanda cox, infographics, new york times
JuiceAnalytics July 26, 2009
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance
analyst,women,looking,at,kpi,data,on,computer,screen
What to Know Before Recruiting an Analyst to Handle Company Data
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

AI takeover life
Artificial IntelligenceInfographic

Are Fears of AI’s Takeover Exaggerated?

8 Min Read

Things You Might Not Know About Big Data [INFOGRAPHIC]

3 Min Read

Big Data Ethics and Your Privacy [INFOGRAPHIC]

4 Min Read

Celebrating the Philae Landing [INFOGRAPHIC]

2 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?