The PTS Blog has a constant stream of great articles on how to better utilize Excel and its charting capabilities. This is one I found quite useful today, how to make clustered, stacked column charts in Excel. Column charts are great, as are stacked column charts. But this shows you how to make stacked column charts with multiple stacked columns per point on the x axis.
Making charts in Excel is something we all do quite frequently. When you make a stacked column chart in Excel, the columns are normally stacked in whatever order you put the series in. Check out this how-to guide for reorganizing the columns so the largest values are on the bottom of each column. Using this approach will help you more easily compare the biggest feature of your data set from one observation to the next.
And here are some other Excel related articles.
Google has brought its search and visualization power to some public data. Check out the Google Blog for more info. For example, if you search for “unemployment rate San Francisco” the first search result will be for this chart. The first data sets available are from the Bureau of Labor Statistics and the Census Bureau’s Population Division.