• Home
  • About Donald
  • Contact Donald

Donald Marron

Musings on Economics, Finance, and Life

Feeds:
Posts
Comments
« Raising Gas Taxes Beats Boosting CAFE Standards
After 20 Years, Sweden’s Labor Market Still Hasn’t Recovered »

Getting the Most from Excel Charts

March 2, 2013 by Donald

Over at The Why Axis, Jon Schwabish has a great show-and-tell on improving economic visuals in Excel. He starts with a chart of job openings data from the Bureau of Labor Statistics that was clearly made using Excel’s default settings (click charts to enlarge):

bls-in11

Jon demonstrates many improvements. I particularly like this one:

bls-in4

To my eye, this chart is way better than the original, although it shares one big flaw: the horizontal spacing of the dots doesn’t match the timing. Jon then corrects that and adds more information (I might have stopped with just getting the spacing right):

bls-in8

Check out his original post for an easy guide to the how and why of these changes and a copy of his Excel file.

Advertisements

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • Email
  • Google
  • Reddit
  • Print

Like this:

Like Loading...

Related

Posted in Data | Tagged Data, Graphics, Visualization | 1 Comment

One Response

  1. on March 4, 2013 at 7:25 am mäklare zlatan

    hey there and thank you for your info – I have certainly picked up something new from right here. I did however expertise some technical issues using this web site, since I experienced to reload the web site many times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I’m complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and can look out for much more of your respective exciting content. Make sure you update this again soon.



Comments are closed.

  • Most Requested

    Tax Policy Issues in Designing a Carbon Tax

    Carbon Taxes & Corporate Tax Reform

    Spending in Disguise

    How Big Is the Federal Government

  • Twitter

    Follow @dmarron
  • Get Updates by Email

    Click Here to Subscribe
  • Get Updates by RSS

    Subscribe in a reader
  • Share or Bookmark

    Bookmark and Share
  • Recent Posts

    • Three Things You Should Know about the Buyback Furor
    • Talking Money, Inflation, Fiat, & Bitcoin
    • How Should Tax Reform Treat Employee Stock and Options?
    • Eight Thoughts on Business Tax Reform
    • The 3-2-1 on Economic Growth: Hope for 3, Plan for 2, Pray it isn’t 1
    • Outside Research Organizations Can’t Replace CBO’s Budget Team
    • Can Trump Make Mexico Pay for the Wall?
    • Taxing carried interest just right
    • Britain Builds a Better Soda Tax
    • Budgeting for Federal Lending Programs Is Still a Mess
    • How Should We Use the Revenue from Taxing Carbon?
    • Happy 70th Anniversary to the Council of Economic Advisers
    • What Should We Do with the Money from Taxing “Bads”?
    • Should Governments Tax Unhealthy Foods and Drinks?
    • Should Governments Tax Products That Are Fun But Harmful?
  • 30-Second Economics

  • Tags

    Accounting Afghanistan Antitrust Arbitrage Auction Auto Banks Baucus Behavioral Economics Birds Budget Budget Process Business CBO Citigroup Climate Change Consumers Corporate Income Tax Data Debt Debt Limit Defense Deficit Economics Economy Energy Environment Europe Fannie Mae Federal Reserve Finance Freddie Mac GDP GM Google Graphics Greece GSE Health Housing Humor Incentives Income Inflation Interest Rates International Internet jobs Life Macroeconomics Measurement Medicare Microeconomics Monetary Policy Mortgage Natural Gas Nature Oil Politics Pricing Recession Regulation Search Social Security Spending Stimulus Stock Market Student Loans TARP Taxes Teaching Tragedy of the Commons Treasury unemployment Warrants
  • Categories

  • Archives

    • April 2018
    • March 2018
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • January 2017
    • October 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • September 2015
    • June 2015
    • May 2015
    • February 2015
    • November 2014
    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • April 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
    • October 2013
    • September 2013
    • August 2013
    • July 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • February 2013
    • January 2013
    • December 2012
    • November 2012
    • October 2012
    • September 2012
    • August 2012
    • July 2012
    • June 2012
    • May 2012
    • April 2012
    • March 2012
    • February 2012
    • January 2012
    • December 2011
    • November 2011
    • October 2011
    • September 2011
    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • March 2011
    • February 2011
    • January 2011
    • December 2010
    • November 2010
    • October 2010
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • May 2009
  • Economics & Finance

    • Brad DeLong
    • Calculated Risk
    • Capital Gains and Games
    • Econbrowser
    • Economist's View
    • EconomistMom
    • Greg Mankiw
    • Infectious Greed
    • Keith Hennessey
    • Marginal Revolution
    • Modeled Behavior
    • Paul Krugman
    • Tax Policy Center
    • The Big Picture
    • The Money Illusion
  • More Fun Blogs

    • Donald and Esther’s Travels
    • Kottke
    • Olivia Judson
  • Seeking Alpha Certified

    Creative Commons License
    The content of dmarron.com carries a Creative Commons license.

    wordpress stat
  • Translate this blog into

    Albanian Arabic Bulgarian Catalan Chinese Simplified Chinese Traditional Croatian Czech Danish Dutch Estonian Filipino Finnish French Galician German Greek Hebrew Hindi Hungarian Indonesian Italian Japanese Korean Lativian Lithuanian Maltese Norwegian Polish Portuguese Romanian Russian Serbian Slovak Slovenian Spanish Swedish Thai Turkish Ukrainian Vietnamese
  • Advertisements

Blog at WordPress.com.

WPThemes.


Cancel
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: