Break out the Bubbly!
Its well past the new year so a little bubbly is long overdue. Bubble charts are great in that they allow you to graph in 3 dimensions: Length, Height and Breadth (or area). Although the steps below are written with Excel in mind, they can also be applied to PowerPoint.
Watch this 3½ minute video to learn the basics regarding interpreting and creating bubble charts.
Creating a Bubble Chart
- Input your data, placing the X-axis data in the first column, Y-axis data in the second column, and the area (bubble size) in the third column.
- Select the data.
- On the Insert tab, in the Chart group, Click XY and select from Bubble types. A Bubble chart is added to the worksheet
Note: If necessary click Switch Row/Column (on the Chart Tools:Design tab) to swap the series data.
Adding Data Labels
- CLICK on one of the bubbles in the series. The entire series becomes selected.
- RIGHT+CLICK one of the selected bubbles and select Add Data Labels. Data labels will appear.
- To format label appearance and content, RIGHT+CLICK on a bubble and select Format Data Labels.
Formatting the Bubble Appearance (Fill)
- CLICK on one of the bubbles in the series. The entire series becomes selected..
- CLICK (again) on the bubble. The single bubble will be selected.
- RIGHT+CLICK on the selected bubble and select Format Data Point. The Format Data Point dialog/pane appears.
- Select Fill and set the fill options (e.g., color, pattern, fill, etc).
- Repeat as necessary for remaining bubbles.
Comments and questions are always welcome!