Microsoft Quick Tip: Visualize Your Data in an Excel Bubble Chart

Microsoft opened the door additional functionality through apps in Office 2013.  If you want to create visual impact for your data in charts and graphics, there are numerous apps or add-ins to meet your need.

For more on add-ins, check out our post: Three Excel Chart Add-Ins to Create Unique Charts and Graphics.

Excel Bubble Chart – Visualize your data in a bubble chart. A bubble chart resembles a scatter chart, but compares sets of three values instead of two – the third value determines the bubble’s size. In other words, the bubble size corresponds to the number of times a specific value appears in the selected data. It serves as a great visual tool to communicate relative population data or to show relationships between data points.

The app allows you to customize bubble colors and arrangement for additional customization.

In this example, the bubbles provide a quick, visual way to compare the numbers of people who give to our charity at different donor levels.

Excel Bubble Chart - Image 1

 

So, try it out! How would you use a bubble chart in Excel?

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

May. 11

Central Time Zone

May. 13

Eastern Time Zone

May. 18

Central Time Zone

May. 20

Pacific Time Zone

May. 24

Eastern Time Zone

May. 26

Central Time Zone

Jun. 2

Central Time Zone

Jun. 8

Eastern Time Zone

Jun. 10

Central Time Zone

Jun. 14

Central Time Zone

Jun. 16

Pacific Time Zone

Jun. 22

Central Time Zone

Jun. 24

Eastern Time Zone

Jun. 28

Central Time Zone

Jul. 7

Eastern Time Zone

Jul. 8

Central Time Zone

Jul. 12

Central Time Zone

Jul. 14

Pacific Time Zone

Jul. 15

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 20

Pacific Time Zone

Jul. 21

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Central Time Zone

Aug. 4

Pacific Time Zone

Aug. 5

Central Time Zone

Aug. 9

Central Time Zone

Aug. 10

Eastern Time Zone

Aug. 11

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 19

Central Time Zone

Aug. 23

Central Time Zone

Aug. 25

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Central Time Zone

Aug. 31

Eastern Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

May. 12

Central Time Zone

May. 14

Eastern Time Zone

May. 19

Central Time Zone

May. 21

Pacific Time Zone

May. 25

Eastern Time Zone

May. 27

Central Time Zone

Jun. 3

Central Time Zone

Jun. 9

Eastern Time Zone

Jun. 11

Central Time Zone

Jun. 15

Central Time Zone

Jun. 17

Pacific Time Zone

Jun. 23

Central Time Zone

Jun. 25

Eastern Time Zone

Jun. 29

Central Time Zone

Jul. 8

Eastern Time Zone

Jul. 9

Central Time Zone

Jul. 13

Central Time Zone

Jul. 15

Pacific Time Zone

Jul. 16

Eastern Time Zone

Jul. 21

Eastern Time Zone

Jul. 21

Pacific Time Zone

Jul. 22

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Central Time Zone

Aug. 5

Pacific Time Zone

Aug. 6

Central Time Zone

Aug. 10

Central Time Zone

Aug. 11

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 18

Eastern Time Zone

Aug. 20

Central Time Zone

Aug. 24

Central Time Zone

Aug. 26

Central Time Zone

Aug. 27

Pacific Time Zone

Aug. 31

Central Time Zone

Sep. 1

Central Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

May. 14

Central Time Zone

May. 19

Eastern Time Zone

May. 25

Central Time Zone

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 17

Central Time Zone

Aug. 23

Central Time Zone

Sep. 1

Pacific Time Zone

Related Charts Articles

Leave a Reply

Your email address will not be published. Required fields are marked *