Archive for Tutorials - page 2

How to Make a Heat Table in Excel

How to Make a Heat Table in Excel

Just because I adore graphs doesn’t mean that I shun data tables. I insert the occasional table inside the body of my report, and each report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide….

Continue reading →

How to Make a Social Network Map with NodeXL

How to Make a Social Network Map with NodeXL

Note from Ann: Today’s guest post is from Johanna Morariu, Director of Innovation Network, AEA DVRTIG Chair, and dataviz aficionado. Basic social network analysis is something EVERYONE can do. So let’s try out one social network analysis tool, NodeXL, and take a peek at the…

Continue reading →

Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel

Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel

I’ve been in love with diverging stacked bar charts since I saw Joe Mako’s submission to Cole Nussbaumer’s dataviz challenge last December. Joe made this contest-winning chart. But in Tableau! The amazing but expensive software! Could I ever create one in Excel?! Yes! Luckily I’d…

Continue reading →

Dataviz Challenge #5: Can You Make a Diverging Stacked Bar Chart?

Dataviz Challenge #5: Can You Make a Diverging Stacked Bar Chart?

Last week I shared strategies for improving any chart’s colors. One of the examples was a diverging stacked bar chart: I love stacked bar charts because they’re pretty versatile, and because they’re a great chart for lots of evaluation and survey data. In my example,…

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 →

Page 2 of 3 1 2 3