=vlookup(): One Excel function to rule them all
Jul 9th, 2014 / Data Analysis
I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining … more »
More »Blog
How to Make a Social Network Map with NodeXL
Nov 1st, 2013 / Data Visualization
Note from Ann: Today’s guest post is from Johanna Morariu, Director of Innovation Network, AEA DVRTIG Chair, and dataviz aficionado. … more »
More »Dataviz Challenge #6: Can You Make a Unit Chart?
Oct 11th, 2013 / Data Visualization
Lately I’ve been feeling let down by summary statistics: the min and max, mean and median, quartiles and standard deviation… They … more »
More »Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel
Sep 6th, 2013 / Data Visualization
I’ve been in love with diverging stacked bar charts since I saw Joe Mako’s submission to Cole Nussbaumer’s dataviz challenge … more »
More »Dataviz Challenge #4: How to Make a Small Multiples Bar Chart in Excel
Jul 27th, 2013 / Data Visualization
Two weeks ago, I challenged readers to re-create the “after” version of a small multiples bar chart. You can read … more »
More »Pivot Tables: Your Tool for Exposing Miscreant Data
Mar 18th, 2013 / Data Analysis
Thank you, Ann Emery and thanks especially to the visitors of AnnKEmery.com. It meant a lot to be asked to do a … more »
More »