Transforming a Table: Four Charts and Four Different Stories

This table came from a grantee's slidedeck. I've anonymized the county names where the grantee was operating, hid the program's name, and changed the numbers of families, but hopefully you can get the gist of it anyway.

This Excel file contains templates used to create the four makeovers: 1) a transposed table, 2) the line chart, 3) the clustered column chart, and 4) the stacked column chart. You can adjust the numbers to match your own work. Don't forget to tweak the titles, colors, and fonts, too.

If you choose to download these materials, you'll be added to my mailing list. You can unsubscribe at any time, but I hope you'll stick around. I share data tricks every week or so.