Jim Hoft of Gateway Pundit blog has long been using a graphic showing the deficits (and a few surpluses) of the last five administrations. Since the graphic only had the projected budget deficit for Pres. Obama’s first year, I decided to update it with more recent numbers. Taking the numbers from the Whitehouse Office of Management and Budget itself, I have updated the graphic with the announced 2009 and 2010 deficits, as well as the deficit the OMB is projecting for 2011.

Here are six variations graphing the current numbers, as of October 2010 February 2011 July 2012 [Now with updated 2013 numbers! -- CM]. Feel free to copy them and use them on your own blogs.

Obama's Deficit

I decided to call out Pres. Obama’s deficits in shades of red. You can also get this in in a much larger size (2250 x 1690 pixels).

Question: where to you get the numbers for the graph? I go to the Office of Management and Budget site and download Table 1.1. I then look at the column D (Surplus or Deficit) to get the numbers for the graph.

Question: how do you convert the surplus/deficit numbers from the table into bars on the graph? Table 1.1 comes down as an Excel file, so I continue to use Excel to convert the surplus/deficit numbers into a count of pixels for each bar. I go to a blank column, like M, and enter the following formula “=D119/8310″. That takes the contents of cell D119 (surplus or deficit for that year) and divides it by 8310, since each pixel represents $8,310,000. Since I can’t have a fraction of a pixel, I format the entire column as a Number with 0 decimal places. Excel does all the rounding up from me. I then take the number of pixels, positive or negative, and draw a bar that many pixels up or down. Once that information has been updated in my master file in Paint Shop Pro, I save out a small and large versions of the image and post them.

UPDATE (2/15/2011 12:26:09 PM): With a new revision of the OMB numbers for 2011 raising the estimated deficit to $1.645 trillion, I have updated the graphics to show the new OMB projection. I have also made two other changes based on feedback. The Bush years text now uses bars rather than arrows (h/t Irene), and I have given Pres. Bush eight years of budgets instead of nine and adjusted all the rest by one (h/t bridgeman).

If you have been using these images, please download and use the current versions. If you want to access the old ones, you may download them all as a single zip file.

UPDATE (7/26/2011 6:00:00 PM): I have updated the images with the finalized 2011 numbers (down 345 billion) and added the projected 2012 budget deficit. I changed from using .jpg to .png for smaller file size and less fuzziness. Based on feedback, I created a large version of one of the images at 2250×1690 pixels that prints better. I also added a credit to this website.

UPDATE (3/2/2013 1:00:00 PM): Since it was requested, I have updated the graphic with the current numbers from Table 1.1 from the Office of Management and Budget site. 2012 is still listed there as an estimate, so I have left it in the graph as pink. I also added the estimate for 2013 to the image. The deficit is projected to go down in 2013, not from lack of spending but from an estimated increase in taxes. We’ll see how that goes.

The image is available in regular (450px x 338px) or large (2250px x 1690px). I have removed the other versions since there has been no demand for them.

UPDATE (5/9/2013 11:07 AM): I just checked the Table 1.1 spreadsheet at the OMB site, and they have published the official 2012 numbers. I’ve updated the graphic with the new numbers and changed it from estimate pink to official red. I also added two questions with answers about where I get the data and how I make the image.

Leave a Reply