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?

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

May. 31

Eastern Time Zone

Jun. 1

Central Time Zone

Jun. 5

Eastern Time Zone

Jun. 7

Pacific Time Zone

Jun. 8

Central Time Zone

Jun. 12

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 15

Eastern Time Zone

Jun. 20

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 26

Pacific Time Zone

Jun. 27

Central Time Zone

Jun. 28

Eastern Time Zone

Jul. 5

Eastern Time Zone

Jul. 10

Eastern Time Zone

Jul. 11

Pacific Time Zone

Jul. 13

Central Time Zone

Jul. 17

Central Time Zone

Jul. 18

Eastern Time Zone

Jul. 19

Central Time Zone

Jul. 20

Pacific Time Zone

Jul. 24

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Eastern Time Zone

Jul. 31

Pacific Time Zone

Aug. 1

Central Time Zone

Aug. 3

Eastern Time Zone

Aug. 8

Pacific Time Zone

Aug. 9

Central Time Zone

Aug. 15

Eastern Time Zone

Aug. 17

Central Time Zone

Aug. 21

Central Time Zone

Aug. 23

Pacific Time Zone

Aug. 24

Eastern Time Zone

Aug. 28

Pacific Time Zone

Aug. 30

Eastern Time Zone

Sep. 6

Eastern Time Zone

Sep. 7

Central Time Zone

Sep. 11

Central Time Zone

Sep. 12

Eastern Time Zone

Sep. 14

Pacific Time Zone

Sep. 18

Pacific Time Zone

Sep. 20

Central Time Zone

Sep. 21

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 27

Eastern Time Zone

Sep. 28

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

Jun. 1

Eastern Time Zone

Jun. 2

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 8

Pacific Time Zone

Jun. 9

Central Time Zone

Jun. 13

Central Time Zone

Jun. 14

Pacific Time Zone

Jun. 16

Eastern Time Zone

Jun. 21

Eastern Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Pacific Time Zone

Jun. 28

Central Time Zone

Jun. 29

Eastern Time Zone

Jul. 6

Eastern Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Pacific Time Zone

Jul. 14

Central Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 20

Central Time Zone

Jul. 21

Pacific Time Zone

Jul. 25

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Eastern Time Zone

Aug. 1

Pacific Time Zone

Aug. 2

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 9

Pacific Time Zone

Aug. 10

Central Time Zone

Aug. 16

Eastern Time Zone

Aug. 18

Central Time Zone

Aug. 22

Central Time Zone

Aug. 24

Pacific Time Zone

Aug. 25

Eastern Time Zone

Aug. 29

Pacific Time Zone

Aug. 31

Eastern Time Zone

Sep. 7

Eastern Time Zone

Sep. 8

Central Time Zone

Sep. 12

Central Time Zone

Sep. 13

Eastern Time Zone

Sep. 15

Pacific Time Zone

Sep. 19

Pacific Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 27

Pacific Time Zone

Sep. 28

Eastern Time Zone

Sep. 29

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

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

Jun. 2

Eastern Time Zone

Jun. 7

Eastern Time Zone

Jun. 9

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 19

Central Time Zone

Jun. 20

Eastern Time Zone

Jun. 29

Pacific Time Zone

Jul. 5

Pacific Time Zone

Jul. 10

Central Time Zone

Jul. 14

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 25

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 8

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 22

Pacific Time Zone

Aug. 23

Central Time Zone

Aug. 28

Eastern Time Zone

Aug. 31

Central Time Zone

Sep. 8

Eastern Time Zone

Sep. 11

Central Time Zone

Sep. 20

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 28

Central Time Zone

Related Charts Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories