November 13, 2020
I was reading this page. The page has several 'graphs' that are rows of dots. i.e. House of Representatives. I'm not sure it actually is called a graph. but I was wondering how we could replicate it in Excel.
I was thinking the values (table) for total woman, democrats, republicans could be dynamic, thus the graph could change as our values changes.
Could Excel even create the total number of seats i.e. 535?
July 16, 2010
Those are waffle charts. You can replicate them in Excel using conditional formatting in cells. I haven't written about them yet (it's now on my to-do list), but PolicyViz.com has this tutorial.
UPDATE: here's a step by step tutorial on how to build Waffle Charts in Excel.