Data Visualization Tips


For nonprofits data visualization and infographics can tell a compelling story about your impact that motivates your audience (donors, board members, volunteers, etc.) to take action and support your mission. Below are some tips to illustrate your data in an attractive, easily digestible format using Microsoft Excel and PowerPoint.

Column Charts

One of the most common charts used in presentations and dashboards, column charts are meant to compare values to each other.  The most common use for a column chart is one set up of data broken up into categories.

Screenshot 2017-03-15 09.56.41.jpg


Here’s what the data above looks like using 3-D bar charts.


Charts default without any vertical or horizontal labels, so you’ll need to add those so people know what the numbers mean. Doing so is easy, at the top of the page, click on Chart Layout and choose Chart Title and Axis Titles to cleary label and enlarge your fonts for your chart. 

Screenshot 2017-03-15 10.00.19.jpg



As you can see, column charts charts is a neat way to either compare categorized data for one data set, or compare categorized data across multiple data sets. For example, the regional chart above shows quite clearly that plumbing expenses are much higher in the North and East.

Increase your Microsoft Productivity Suite skills with short training videos on Word, Excel and PowerPoint.

New Call-to-action


Topics: Microsoft Excel
View the original article from Make Use Of   Featured Image Courtesty of iStockPhoto/Violka08
Have technology questions or want to learn more about how Tech Impact can help your nonprofit?