From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Bubble charts

Bubble charts - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Bubble charts

“

- [Instructor] All right, next up we've got bubble charts. Bubble charts are really, really similar to scatter plots. The only difference is that they add a third dimension, which is the size of the bubble, to the original scatter plot format. So whereas a scatter plot plots x and y values, the bubble chart essentially plots x, y, and z where z is the size of the points of the markers. So some examples here, maybe you're plotting product sales on your x-axis, revenue on your y-axis. You could use something like market share as the size of your bubbles where each bubble represents a company. Or you could look at income per capita on your x, life expectancy on your y, and population as your size by country. So pro tips in terms of bubble charts, you do have the option to use custom color formatting as a fourth dimension to even further differentiate categories. Just keep in mind that if it doesn't add any value or if it's not really necessary, it may just make the picture a bit more…

Contents