Wednesday, April 24, 2013

4KCBWDAY3 Infographic

Today's prompt is to create an infographic describing something in your knitting. For mine, I plugged a couple of numbers into Excel and hit "insert pie chart".

I went through my project page on Ravelry to get the numbers, though I suspect they are slightly skewed. I have a bad habit of not adding things to my project page. I think I've completed a lot more than 88 projects since I started Ravelry, and I know I've frogged more than just 2 (although, to be fair, most of the frogged  items did get reworked into new versions of themselves. I seldom abandon a project completely. See "bull-headedness," yesterday's post).

And since making pretty pictures in Excel is easy and fun, here's another one for you:

 I'm kind of surprised at the percentage of baby/doll items compared to everyone else, since I really don't make them that often. Then again, I can finish a doll hat in less than an hour, so they aren't exactly a huge commitment. I did think that socks would be a larger part, but maybe that's just because I'm a slow sock knitter. I only make about 2 pair a year, at most.

So that's your daily dose of infographic. Anyone else having fun with this tool?


  1. I cannot use Excel for the life of me :) My projects are skewed because I keep forgetting to tag them correctly ...

    1. I'm horrible at it, but these charts are really easy--two columns: Project Type and Number of Projects. Down one side, it reads socks, hats, etc. The other is the number of that type. Highlight, click the insert tab and the pie chart button. The computer does the rest!

  2. Nifty, I should tally up all my projects. I did a pie chart based on the fiber content in my stash.

  3. I admire your perseverance in using Excel for this. My Excel (for Mac) is not as user friendly as it is on a Windows computer. I like the comparison between what gets finished and what you've actually made.

  4. Lovely charts! Amazing rate of finished pprojects.

    Here's mine: