9.09.2009

 

Super Pie

I've been reading a few excel blogs lately, including a few that focus on making charts look better and easier to interpret. I admit, the handy pie chart has always looked a little cluttered, and it required a long explanation of what the various components were when I first posted it. To some extent it still does, because most (all?) of my audience is unfamiliar with the pathway to the ASA credential. But the new improved Super Pie Chart should be a little more visitor friendly.

Pie chart of Jack's progress toward ASA.

The major categories of the requirements are grouped by color—blue for exams, red for VEE credits, green for the FAP modules, and purple for the APC—and each color region is labeled. Darker wedges in each range show completed requirements (all of the VEEs are complete) while lighter wedges represent outstanding requirements. The text for each wedge fits in place (except for the APC, which floats above), removing the clutter of all those leader lines on the old chart.

The only new progress on this incarnation is the addition of Module 1 from the FAP modules, which I completed earlier this summer. At the moment I am studying for Exam C, which I will take in early November, and I will start working on the FAP modules again while I wait for my result.

—Jack

Labels: ,

 

Comments:

I guess it is time for a new shirt, eh?

# posted by Blogger OldBikeRider : 9/09/2009 9:15 PM  

mmmmm.... key lime, cherry and blueberry all in one glorious pie.

# posted by Blogger tedspeed : 9/10/2009 6:13 AM  

I like how John thinks. =)

# posted by Blogger erica : 9/16/2009 8:35 AM  

It's a take off on the old Cheech and Chong "Look at da colors, man!" I really like what excel can do with a boring old pie chart!

# posted by Blogger Mom A : 9/17/2009 6:41 PM  

Go Jack!

# posted by Blogger Mom A : 9/17/2009 6:42 PM  

Post a Comment

< Jack's Page