Tag archive for tutorial

Sorting Your Bar Charts

Sorting Your Bar Charts

“Ann, my bar chart is upside down! Help!” You read my prior post about using horizontal bar charts for nominal variables like favorite fruits. My toddler is eating two! bananas a day so bananas are the winner in this fictional fruit contest. Our original table…

Continue reading →

Heat Table How-To in Excel

Heat Table How-To 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 →

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: 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 →