Category Archives: Blogroll

Interesting new blog: Charts and Things

image I started following (via my preferred RSS reader: Google Reader) a blog by John Peltier, of Peltier Technical Services, called PTS Charts and Things.  I have been utterly fascinated by a few of his recent posts where he takes on the challenge of producing a chart of a particular form using the features built-in to Excel 2007. 

These are not trivial tasks. Consider for example the Clustered Stacked Bar graph (see below). First off, it is a challenge, in and of itself, to create the clustering of stacked bar graphs, since there are clustered bar graphs in Excel and stacked bar graphs in Excel, but no combination of both.  On top of that, labeling the axes correctly turns out to be particularly tricky.  And yet, John Peltier walks you step by step through his process of developing the graph. I especially enjoy his presentation because it doesn’t just walk through how to do it, but also through the entire trial and error process of getting the desired graph.

image

Another recent favorite post of mine was his presentation on the  Stacked Area Chart Challenge:

image

He also posted a nice rundown of the Changes to Charting in Excel 2007.  Since I personally love the new interface and features in Office 2007 and a colleague of mine at Wayland has expressed his dislike of the new Excel 2007, I enjoyed reading an outside opinion.  I stand by my original position but understand a little more of the problems with the new user interface.

The PTS blog also pointed me to a new blog (see below) to which I just subscribed.  I’ll follow it for a while, but having already read the first few posts, I think it is going to be a keeper.

Daily Dose of Excel

image

Mariachi on the River Walk

"Cowabunga!!"  I know that the name of the following song is no where close to this but it is the closest word in my vocabulary (and no, this is not a regularly used word)

This video was captured by Robert over at CastingOutNines during my recent visit to San Antonio.  You can see me up front gettin’ jiggy with it.  Maria is also there snapping some photos.  We had a couple other guests with us too.  Hopefully it won’t be long before they’re convinced to join the blogosphere (when did that word start to sound old?)

Click here to enjoy the video.

Thanks to Robert for posting.