Marketsmart Blog

2 of the Most Important Fundraising Charts You'll Ever See

Thanks to AFP's Growth-In-Giving Initiative, you now have a very simple way to evaluate your organization's year-over-year results for gains and losses. On their web page you can also find free downloadable Excel files to help you dump your numbers in so you can review and analyze your results.

AFP Gigi chart

Once you've done that you'll need to determine the 80/20 for both your gains and losses. You can do that using Pareto Charting in Excel. Here's how to do it.

The chart below shows that a small number of donors delivered the biggest donations (shown with red dots connected by red lines). An analysis of most nonprofits' revenues will result in a chart like this. Although, nowadays, many are seeing it become a 90/10 chart instead of 80/20.

Pareto charting for fundraising

Majorgivingnow.org is an initiative funded by the Corporation for Public Broadcasting. They created an Excel file you can use too. You can get it here at the top of the page.

 

I believe, if you monitor your gains vs. losses and focus on the 80/20, you can't lose. Let me know if you agree.

 

LIKE THIS BLOG POST? PLEASE SHARE IT AND/OR SUBSCRIBE

Posted byGreg Warner

March 13, 2015

Get Weekly Tips

Get captivating motivational quotes~hand-picked for major and planned giving fundraisers~delivered via email every Tuesday.

Get Motivated

DOWNLOAD OUR FREE EBOOK

eBook Image

A Fundraising Guide for Nonprofits
Get My Copy

Connect with MarketSmart

Our Awards



Press Releases