From the course: Excel: Charts in Depth

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Bubble charts

Bubble charts

- [Instructor] Now, the next sheet to the right, called Bubble Chart, also allows us to work with relationships. Here we've got three sets of numbers. Now, clicking here, and let's say you wouldn't necessarily know that a bubble chart exists, but let's say we've been given a clue. So, as with the scatter chart, Insert, off to that same icon, click the button, Bubble. 3D version looks more interesting. Now, what isn't so obvious here, and it's something you'd either have to be clued in on or just discover maybe by mistake, this is not quite right yet. It's not showing us things that we want. From time to time, when a chart is not giving you what you want, and you've explored some options and you don't know where to turn next, consider going on the Chart Design tab to change chart type, and then possibly into Recommended Charts. Do we see anything out here? Well, there's bubble chart again, but now it looks a…

Contents