Project QUILTING–Charts and Graphs

I have a secret.  I secretly love excel and all that I can do with it.  Since the Focus Through the Prism Challenge has so much to do with color I thought it would be fun to watch which colors everyone is using each month. 

Fullscreen capture 7242015 101943 PM

I couldn’t decide which format I liked the information in best.  Here is the bar graph showing how many quilts were made for each color per challenge.

Fullscreen capture 7242015 101949 PM

And here is the line chart that shows how the colors are used in each challenge. 

Which way do you prefer to look at the data?  Or do you think I’m just absolutely crazy?!

Don’t worry … I’m pretty sure I’ll keep updating both the charts and graphs as the challenges progress.

4 comments:

  1. Bar Chart. Or maybe a Pie Chart. Mmmm, pie.

    ReplyDelete
  2. Definitely bar chart...and REALLY like the pie chart idea too! Your second diagram was too hard to read. ;)

    ReplyDelete
  3. Definitely bar chart...and REALLY like the pie chart idea too! Your second diagram was too hard to read. ;)

    ReplyDelete
  4. Bar graph for sure! It is categorical data. I LOVE Excel. Have you tried pivot tables?

    ReplyDelete

Thank you for your comments! I do my best to reply but life sometimes gets in the way. I do read and appreciate each and every comment!

*some posts on this blog contain affiliate links to vendors such as Amazon - at no additional cost to you. The small amount of affiliate income I earn allows me to bring you free patterns and DIY tutorials, as well as pay for domain fees. For more information, please visit my Disclosure Statement and Advertising Policies page.