VizWiz

Launch, grow, and unlock your career in data
Showing posts with label butterfly chart. Show all posts

August 23, 2023

#MakeoverMonday Week 34 - Go-To Drinks for Men and Women on Dates

No comments

Join me for live analysis of Zoosk's recent survey, covering 8,793 members' dating drink preferences! 

In this livestream, I'll break down the responses across 7 different drink types, comparing the preferences between men and women. 

Is there a gender divide when it comes to what people choose to drink on dates?  

I'll explore this question and more. 

July 11, 2023

#MakeoverMonday 2023 Week 28 - Global Passport Rankings

No comments
This week's data set only contained one measure, two years, and country names. This meant that I had to focus on charts that help visualize comparisons.

I created:

  1. Grouped bar chart
  2. Bar in bar chart
  3. Grouped bar chart with a gantt bar for the difference
  4. Diverging bar chart
  5. Histogram
  6. Butterfly chart
  7. Barbell chart
  8. Scatter plot
  9. Slope graph
  10. Trellis chart
  11. Jittered bar chart

Wow. I didn't realize I had tried so many chart types. No wonder the hour went by so quickly.

I didn't love any of the charts, so I went with the one that I thought was the best of the bunch. Check it out below the video.

If you find the video useful, please give it a like on YouTube and subscribe to my channel. That helps other people find the content too.

Lastly, remember to sign up for my newsletter at andykriebel.com. You get sneak peaks of new videos, advice to help you be better at your job, plus exclusive discounts to products I create.


June 7, 2021

#MakeoverMonday 2021 Week 23: The Percentage of Never Married is on the Rise

No comments
This week I iterated through 12 charts and a dashboard in 50 minutes. Once again, I ended up with a bar chart. They're rarely going to let you down. The only other bit I added was the thinner bar showing the change from 2006 to 2016.

Resources:
  1. Final Viz (and below)
  2. Preferences file (all of my custom color palettes)
  3. How to Create a Combination Bar Chart & Candlestick Chart 


February 8, 2021

#MakeoverMonday Week 6: Why Are Women Perceived to Be Unequal to Men?

No comments

Wow! What a fun #WatchMeViz that was! I iterated through 16 charts and then when the idea solidified, there was some great conversation and feedback on the chat to help me get to the end. I find survey responses quite difficult to visualize, so instead of getting frustrated, I thought about all of the ways I can compare data to see if anything would work.

Most importantly, thank you to all of your on the live chat. It makes a huge difference to me and I love getting your feedback and questions along the way. You make me better. You can find the final visualization below the video.


December 1, 2020

How to Create an Evenly Distributed Butterfly Chart

No comments

A Butterfly Chart is (typically) a bar chart where two sets of data series are displayed side by side. The purpose is to allow you to compare the two data series across a dimension. 

Here is an example of a butterfly chart I created for Makeover Monday.


Notice how I have zero at the center and the scales are the same on either side of zero. This helps show how the chart "leans" to one side or the other.

The comparisons would be more difficult to see if the left and right hand sides of the butterfly did not have the same axis scale. In this video, I show you how two examples for creating a butterfly chart.

February 9, 2017

Workout Wednesday: How Will the UK population Change By 2039?

No comments
Another fun Workout Wednesday challenge from Emma this week. She asked us to build a butterfly chart, something I'd never done before.

Conceptually, I knew exactly what I needed to do:

  1. Create separate measures for males and females
  2. Create additional measures to make them percentages by dividing by the population estimate
  3. Create an LOD for the national average for males and females
  4. Create additional measure to make them percentages
  5. Make the male axis reversed
  6. Set all of the axes scales to be equivalent (Emma didn't do this, but I think the axes should be the same on each side of the center)
  7. Create the calcs for the rows and columns of the trellis
  8. Add a filter for local authority and add that to the title
  9. Throw is all together in a dashboard size 1000x800
I tend to jot these things down in the Notes app as I think of them. It helps me remember what I need to do for weeks like this when I don't get it done on Wednesday.

I'm posting an image here, but if you want to see the interactive version, tap on the image.