A Bubble chart shows circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.
Just follow these steps to create a bubble chart:
- Select the data. The table should have X, Y co-ordinates and Bubble sizes in 3 columns.
- Insert a bubble chart by going to Insert > chart > bubble chart
- Format the chart by removing grid lines, adjusting bubble colors, bubble sizes.