Use Data Bars and Icon Sets to Major League Baseball Standings using Excel 2010

I believe that one of the best tools available for visualizing data within an Excel spreadsheet is conditional formatting. This post will feature what you can do with data bars and icon sets. See my earlier my post on how easy it is to use conditional formatting to find duplicates in Excel. In this post, I am using some data from major league baseball to explore how to visualize win/loss streaks and comparing team’s winning percentages. The example spreadsheet represents MLB standings as of 7/27/2012. I copied the data from  and pasted it into an Excel spreadsheet which you can download (see link at end of post). The following screen shot represents the data before any applied conditional formatting.

Excel Conditional Formatting 1

The first step to take is select the data that you would like to apply the conditional formatting to. I selected the range from C4 through C39. After selecting your data, click the home tab–>conditional formatting command–>data bars. The data bars will grant you a lot of choices. Simply click the one that you like the best.

Excel Conditional Formatting Data bar choices

As you can see in the screen shot above, I applied the data bars to the winning/loosing streaks. So Cincinnati currently have a 7 game winning streak and the data bar on its record is displayed to the right and is green. This is a great news for Cincinnati fans. Contrast that with Milwaukee Brewers who have a 7 game loosing streak and its data bar is to the left and is red. Now I could customize the colors and select what color I would like the data bar to be for positive numbers and what color I would like to be for negative colors under manage rules.

Another great choice for conditional formatting is the icon sets. Icon sets group your data into parts. For example, in the screen shot below I selected all the baseball teams winning percentage (Range F4:F39). Then I clicked conditional formatting–>icon sets–>traffic lights. This grouped the data with the top 3rd winning teams with green traffic lights, the middle third with yellow traffic lights, and the bottom third teams with red traffic lights.

Excel Conditional Formatting icon set choices

Download my baseball mlb conditional formatting.xlsx file. I’ve included a practice sheet that you can work with.

Final Excel conditional formatting

Be sure to download my Excel keyboard shortcuts handout if you haven’t already.

About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel and tagged , . Bookmark the permalink.

One Response to Use Data Bars and Icon Sets to Major League Baseball Standings using Excel 2010

  1. Pingback: The Top 10 Posts of 2012 on my 1 year Blog Anniversary | Steve Chase Docs

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s