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

Sep. 26

Pacific Time Zone

Sep. 27

Central Time Zone

Sep. 29

Central Time Zone

Oct. 3

Central Time Zone

Oct. 5

Central Time Zone

Oct. 6

Eastern Time Zone

Oct. 11

Eastern Time Zone

Oct. 12

Central Time Zone

Oct. 13

Pacific Time Zone

Oct. 17

Eastern Time Zone

Oct. 18

Central Time Zone

Oct. 24

Pacific Time Zone

Oct. 26

Central Time Zone

Oct. 27

Eastern Time Zone

Oct. 31

Central Time Zone

Nov. 2

Pacific Time Zone

Nov. 3

Eastern Time Zone

Nov. 7

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 9

Pacific Time Zone

Nov. 14

Pacific Time Zone

Nov. 15

Eastern Time Zone

Nov. 17

Central Time Zone

Nov. 28

Eastern Time Zone

Nov. 30

Pacific Time Zone

Dec. 1

Central Time Zone

Dec. 5

Central Time Zone

Dec. 7

Eastern Time Zone

Dec. 8

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 19

Pacific Time Zone

Dec. 20

Central Time Zone

Jan. 4

Eastern Time Zone

Jan. 5

Central Time Zone

Jan. 9

Central Time Zone

Jan. 11

Eastern Time Zone

Jan. 12

Pacific Time Zone

Jan. 17

Pacific Time Zone

Jan. 18

Central Time Zone

Jan. 19

Eastern Time Zone

Jan. 23

Eastern Time Zone

Jan. 24

Central Time Zone

Jan. 25

Pacific Time Zone

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

Microsoft® Excel®: Beyond the Basics

Sep. 27

Pacific Time Zone

Sep. 28

Central Time Zone

Sep. 30

Central Time Zone

Oct. 4

Central Time Zone

Oct. 6

Central Time Zone

Oct. 7

Eastern Time Zone

Oct. 12

Eastern Time Zone

Oct. 13

Central Time Zone

Oct. 14

Pacific Time Zone

Oct. 18

Eastern Time Zone

Oct. 19

Central Time Zone

Oct. 25

Pacific Time Zone

Oct. 27

Central Time Zone

Oct. 28

Eastern Time Zone

Nov. 1

Central Time Zone

Nov. 3

Pacific Time Zone

Nov. 4

Eastern Time Zone

Nov. 8

Eastern Time Zone

Nov. 9

Central Time Zone

Nov. 10

Pacific Time Zone

Nov. 15

Pacific Time Zone

Nov. 16

Eastern Time Zone

Nov. 18

Central Time Zone

Nov. 29

Eastern Time Zone

Dec. 1

Pacific Time Zone

Dec. 2

Central Time Zone

Dec. 6

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 16

Eastern Time Zone

Dec. 20

Pacific Time Zone

Dec. 21

Central Time Zone

Jan. 5

Eastern Time Zone

Jan. 6

Central Time Zone

Jan. 10

Central Time Zone

Jan. 12

Eastern Time Zone

Jan. 13

Pacific Time Zone

Jan. 18

Pacific Time Zone

Jan. 19

Central Time Zone

Jan. 20

Eastern Time Zone

Jan. 24

Eastern Time Zone

Jan. 25

Central Time Zone

Jan. 26

Pacific 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

Sep. 27

Eastern Time Zone

Sep. 28

Central Time Zone

Oct. 4

Central Time Zone

Oct. 5

Eastern Time Zone

Oct. 11

Central Time Zone

Oct. 12

Pacific Time Zone

Oct. 20

Central Time Zone

Oct. 21

Eastern Time Zone

Oct. 24

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 7

Central Time Zone

Nov. 10

Pacific Time Zone

Nov. 15

Central Time Zone

Nov. 17

Eastern Time Zone

Nov. 29

Pacific Time Zone

Nov. 30

Central Time Zone

Dec. 5

Eastern Time Zone

Dec. 9

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 21

Pacific Time Zone

Jan. 4

Central Time Zone

Jan. 9

Pacific Time Zone

Jan. 10

Eastern Time Zone

Jan. 17

Central Time Zone

Jan. 18

Eastern Time Zone

Jan. 26

Central Time Zone

Jan. 27

Pacific 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