Indzara - Simple and Effective Templates | 4 types of analysis with Motion Bubble Charts & Scatter Plots @indzara | Uploaded 2 years ago | Updated October 03 2023
Motion charts or animated charts, allow us to express the data in ways that a static chart does not. In this video. I will talk about four types of analysis that we can do using motion or animated bubble charts.
#dataviz #excel #excelcharts
Video demo of free template: https://www.youtube.com/watch?v=YiKA1B6VE7M
Download Free template: https://indzara.com/2021/09/motion-bubble-chart-excel-template/
For more https://indzara.com/dataviz
Before I start with the analysis techniques, if you have not watched this presentation by Hans Rosling https://youtu.be/hVimVzgtD6w?t=212 please go check it out. It's a very popular, famous video where he shows the data in a very effective and engaging way, telling a story from the data using these animated bubble charts. Data was sourced from https://www.gapminder.org/data/
4 types of analysis I cover in this video
1. Movement of bubbles as a total population
2. Movement of cohorts of bubbles
3. Movement of one bubble in a cohort
4. Movement of one versus another bubble
There are two things important when it comes to motion charts or animated charts. First is the direction. So in this case, we saw how the bubbles mode from one place to another one spot on the chart to the other, the second is the Speed. How fast it moves.
Please make sure that you pay attention to the axis. So for example, in this case, I have kept both the X and the Y axis exactly fixed. So they don't change when the data is changing. So if you do it as a default then Excel, for example, may try to readjust the scale that you don't want to do that because you are then introducing another dimension which will be kind of difficult to comprehend. And it may give you a misleading picture also. So I would recommend in this context, you know, keep those X and Y axis fixed.
I think this is a very effective technique and you don't even have to speak or tell a story along with this presentations because the data itself speaks. The visual itself speaks to the audience. They, as long as they know what the X and Y axis are, they can understand the message themselves without you having to go through bullet points and, you know, make a big speech that is the power of this visualization technique, animated, scatterplot, animated bubble charts can be very effective.
If you have other types of analysis that you would recommend or suggest that we should be doing with these bubble charts, I would love to hear from you, please post them in the comment section below.
Thank you very much for watching.
Motion charts or animated charts, allow us to express the data in ways that a static chart does not. In this video. I will talk about four types of analysis that we can do using motion or animated bubble charts.
#dataviz #excel #excelcharts
Video demo of free template: https://www.youtube.com/watch?v=YiKA1B6VE7M
Download Free template: https://indzara.com/2021/09/motion-bubble-chart-excel-template/
For more https://indzara.com/dataviz
Before I start with the analysis techniques, if you have not watched this presentation by Hans Rosling https://youtu.be/hVimVzgtD6w?t=212 please go check it out. It's a very popular, famous video where he shows the data in a very effective and engaging way, telling a story from the data using these animated bubble charts. Data was sourced from https://www.gapminder.org/data/
4 types of analysis I cover in this video
1. Movement of bubbles as a total population
2. Movement of cohorts of bubbles
3. Movement of one bubble in a cohort
4. Movement of one versus another bubble
There are two things important when it comes to motion charts or animated charts. First is the direction. So in this case, we saw how the bubbles mode from one place to another one spot on the chart to the other, the second is the Speed. How fast it moves.
Please make sure that you pay attention to the axis. So for example, in this case, I have kept both the X and the Y axis exactly fixed. So they don't change when the data is changing. So if you do it as a default then Excel, for example, may try to readjust the scale that you don't want to do that because you are then introducing another dimension which will be kind of difficult to comprehend. And it may give you a misleading picture also. So I would recommend in this context, you know, keep those X and Y axis fixed.
I think this is a very effective technique and you don't even have to speak or tell a story along with this presentations because the data itself speaks. The visual itself speaks to the audience. They, as long as they know what the X and Y axis are, they can understand the message themselves without you having to go through bullet points and, you know, make a big speech that is the power of this visualization technique, animated, scatterplot, animated bubble charts can be very effective.
If you have other types of analysis that you would recommend or suggest that we should be doing with these bubble charts, I would love to hear from you, please post them in the comment section below.
Thank you very much for watching.