Tag archive for Analysis

=vlookup(): One Excel function to rule them all

=vlookup(): One Excel function to rule them all

I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining datasets, like when you’ve got program participants’ demographic data in one place and their scores or outcomes in another place. I can’t tell you how many…

Continue reading →

Dataviz Challenge #4: How to Make a Small Multiples Bar Chart in Excel

Dataviz Challenge #4: How to Make a Small Multiples Bar Chart in Excel

Two weeks ago, I challenged readers to re-create the “after” version of a small multiples bar chart. You can read the full post here. Congratulations to the 6 contestants! Click on the contestant’s name to see their chart. James Coyle Sara Vaca Elisa Avila Angie…

Continue reading →

Dataviz Challenge #3: Alternate Solution by Paul Denninger

Dataviz Challenge #3: Alternate Solution by Paul Denninger

Note from Ann: Last week I shared a dataviz how-to guide. Paul Denninger has a great alternative solution to share! He uses hidden bars, also known in the Excel community as floating bars or white bars, to build “two” charts in one. Enjoy! Getting excel…

Continue reading →

Dataviz Challenge #3: How to Make a Side by Side Bar Chart in Excel

Dataviz Challenge #3: How to Make a Side by Side Bar Chart in Excel

Two weeks ago, I challenged readers to re-create the “after” version of a side by side bar chart. You can read the full post here. Congratulations to the 9 contestants! Click on the contestant’s name to see their chart. Regan Grandy Sara Vaca Alex Kadis…

Continue reading →

Dataviz Challenge #3: Can You Make a Side by Side Bar Chart?

Dataviz Challenge #3: Can You Make a Side by Side Bar Chart?

Thanks to everyone who participated in the first and second dataviz challenges! I hope these challenges give you a chance to practice and build upon your Excel and visualization skills. Last time, we made a streamlined version of the basic bar chart by adjusting Excel’s…

Continue reading →

Page 1 of 2 1 2