This submission is a first for HelpMeViz. A foundation sent in their data and need help visualizing the data. Have fun.

This spreadsheet summarizes the 300 grants awarded by our foundation in the past year. It includes the type of grant awarded, length, amount, geographical area served, and programmatic focus area. We regularly track this information in spreadsheets but we have never visualized the information in any charts. Sometimes it’s helpful for us to break out the information (for example, by geographical area or program area) but overall patterns are also useful for us to see. We’re not sure where to start and would appreciate any ideas, from simple sketches, to a chart(s), to a 1-page graphical summary like a dashboard or infographic. Thank you!

(Photo credit: Leo Reynolds via Compfight cc)