From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use bubble charts to show relationships between sets of values

Use bubble charts to show relationships between sets of values - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use bubble charts to show relationships between sets of values

“

- [Instructor] Excel has a number of colorful charts, 2 and on the screen we're seeing one of them. 3 It's called a bubble chart. 4 And as always with charts, you want to be thinking, 5 if I'm making a presentation of this, 6 will I be spending too much time explaining how to read it? 7 That could be the case with these. 8 And yet, with a certain amount of data, 9 these could be valuable charts. 10 A bubble chart can actually show us 11 three measures at the same time. 12 As I point to one of these bubbles, 13 the one right here that has the 46 on it, 14 we can see two things coming out of this, 15 simply based on the axes information. 16 The horizontal axis at the bottom of the screen 17 represents age. 18 This person happens to be 46. 19 Now, the label is on there already. 20 That doesn't necessarily have to be there, 21 but the bubble is positioned so that the age is 46. 22 Looking horizontally to the left, 23…

Contents