{"id":404,"date":"2017-08-24T16:39:18","date_gmt":"2017-08-24T21:39:18","guid":{"rendered":"http:\/\/web.education.wisc.edu\/nwhillman\/?p=404"},"modified":"2017-08-24T16:41:30","modified_gmt":"2017-08-24T21:41:30","slug":"waffle-chart-in-excel","status":"publish","type":"post","link":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/2017\/08\/24\/waffle-chart-in-excel\/","title":{"rendered":"Waffle chart in Excel"},"content":{"rendered":"

Below are two ways to display the same data.<\/p>\n

The first is a trusty old pie chart.<\/p>\n

The second is its cooler pastry cousin, the waffle chart.<\/p>\n

\"\"<\/a> \"\"<\/a><\/p>\n

These data are from IPEDS, just a quick count of public college undergraduates by their college’s selectivity.<\/p>\n

We can see in both charts the majority enroll in open-access colleges. But the waffle is easier on the eye, I think.<\/p>\n

Turns out, the choice between pies and waffles can be contentious<\/a>.<\/p>\n

If you’re like me, you probably want to use a waffle chart to display your data sometime.<\/p>\n

You can make one of these in R using the “waffle<\/a>” command…if you are familiar with that program. I, sheepishly, am not.<\/p>\n

For those of us still in the old school, I made this waffle chart in Excel. Please feel free to use in your own work, but keep in mind this will only work for up to four slices of pie.<\/p>\n

Download this Excel file<\/strong>: waffle template<\/a><\/p>\n

Step one:<\/strong> Enter up to four category names in cells B3:B6<\/p>\n

Step two:<\/strong> Enter percentages (high to low) in cells C3:C6. The template is just filling these with random numbers as a placeholder.<\/p>\n

Step three:<\/strong> Choose which chart you like better, the square waffle or the rectangle waffle. Both charts link to the same data.<\/p>\n

Note:<\/strong> You’ll see two other tabs in this file, “chart 1” and “chart 2,” which are the underlying formulas driving the chart. Just pretend they’re not there.<\/p>\n

I created and modified this based on a helpful guide found here<\/a>. If you end up using this file, please let me know if you detect any bugs. I think I’ve worked them out, but don’t hesitate to contact me if you see any or have suggestions.<\/p>\n","protected":false},"excerpt":{"rendered":"

Below are two ways to display the same data. The first is a trusty old pie chart. The second is its cooler pastry cousin, the waffle chart. These data are from IPEDS, just a quick count of public college undergraduates by their college’s selectivity. We can see in both charts the majority enroll in open-access […]<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-404","post","type-post","status-publish","format-standard","hentry","category-community-college-research"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/comments?post=404"}],"version-history":[{"count":0,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/404\/revisions"}],"wp:attachment":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/media?parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/categories?post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/tags?post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}