{"id":635,"date":"2020-06-24T00:22:17","date_gmt":"2020-06-23T22:22:17","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=635"},"modified":"2024-05-04T16:45:26","modified_gmt":"2024-05-04T14:45:26","slug":"bubble-chart-3-variables-on-a-chart","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/","title":{"rendered":"Bubble Chart with 3 Variables On A Chart"},"content":{"rendered":"<p>A Bubble Chart is an extension of the <span style=\"color: #0000ff\"><strong><a title=\"XY Scatter Chart: Related Variables\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/xy-scatter-chart-related-variables\/\" target=\"_blank\" rel=\"noopener noreferrer\">XY Scatter Chart<\/a><\/strong><\/span>. Bubble Chart with 3 variables adds a 3rd variable to each point in the XY Scatter Chart. XY Scatter plots x and y values and Bubble Chart plots x values, y values, and z (size) values.<\/p>\n<p>Bubble Chart is extremely useful to graphically represent three <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\">dimensions of data<\/a> and show the relationship between them.<\/p>\n\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p>&lt;!&#8212;-&gt;<\/p>\n<\/div>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/#What_is_a_Bubble_Chart\" title=\"What is a Bubble Chart?\">What is a Bubble Chart?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/#How_to_Create_a_Bubble_Chart\" title=\"How to Create a Bubble Chart?\">How to Create a Bubble Chart?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/#Formatting_a_Bubble_Chart\" title=\"Formatting a Bubble Chart\">Formatting a Bubble Chart<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/bubble-chart-3-variables-on-a-chart\/#Pros_and_Cons_of_using_Bubble_Chart\" title=\"Pros and Cons of using Bubble Chart\">Pros and Cons of using Bubble Chart<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"What_is_a_Bubble_Chart\"><\/span><a id=\"what-is-a-bubble-chart\"><\/a>What is a Bubble Chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bubble Chart is used to visualize data with three dimensions. Instead of plotting just two variables (x and y) in a traditional chart, Bubble Chart lets you add a third variable as well. The first variables are visualized as coordinates, the third as the size of the bubble.<\/p>\n<p>This chart can be used when you have a third value that can be used to determine the relative size of the bubble. <em>Higher the value, the bigger will be the size of the bubble.<\/em><\/p>\n<p>For example, if you have a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/draw-a-logo-with-a-scatter-chart\/\" target=\"_blank\" rel=\"noopener\">Scatter Chart<\/a> that shows the relationship between the age of a house and its proximity to the city and want to add the value of the house (the 3rd variable), then a Bubble Chart will get you there.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_a_Bubble_Chart\"><\/span><a id=\"how-to-create-a-bubble-chart\"><\/a>How to Create a Bubble Chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This Excel graph with 3 variables is very easy to create in Excel. Let&#8217;s see how to cre<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-slope-of-tangent-line-in-excel\/\" target=\"_blank\" rel=\"noopener\">a<\/a>te a scatter plot in Excel with 3 variables with the help of some examples.<\/p>\n<p>Download the Excel Workbook and follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\" style=\"text-align: left\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Bubble-Chart.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Bubble-Chart.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook<\/span><span class=\"postTitle px-3\">Bubble-Chart.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<h3><span style=\"color: #ff0000\">Example 1:<\/span><\/h3>\n<p>In the table, you have the age of the house, proximity to the city (in km) and the value of the house. So, using Bubble Chart with 3 variables, you can plot the <em>age of the house<\/em> on the X-axis, the<em> proximity to the city<\/em> is on the Y-axis and the <em>value of the house<\/em> (the 3rd variable) as the size of the bubble.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4557\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"466\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png 466w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01-300x223.png 300w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/a><\/p>\n<p>Follow the steps below to understand how to create a bubble chart with 3 variables:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Select the\u00a0<strong>table\u00a0<\/strong>on where we want to create the chart<strong>. \u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4557\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"466\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01.png 466w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-01-300x223.png 300w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span>\u00a0Go to\u00a0<strong>Insert &gt; Insert <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xy-scatter-chart-related-variables\/\" target=\"_blank\" rel=\"noopener\">Scatter Chart<\/a> or Bubble Chart &gt; Bubble<\/strong><em>.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-216.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18213\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-216.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"915\" height=\"403\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-216.png 915w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-216-300x132.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-216-768x338.png 768w\" sizes=\"(max-width: 915px) 100vw, 915px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>:<\/span>\u00a0Click on <strong>Series1<\/strong> and Click <strong>Delete <\/strong>to remove it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4559\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-03.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"577\" height=\"404\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-03.png 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-03-300x210.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p>The horizontal axis contains <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-negative-values-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">negative values<\/a> as well. Since X-axis represents the age of the house, it cannot be negative. Formatting this axis to restrict negatives value is a good idea to avoid confusion.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4<\/strong>:<\/span> Right Click on the axis and select<strong> Format Axis<\/strong> to\u00a0open the <strong>Format Axis Panel<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-221.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18219\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-221.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"592\" height=\"332\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-221.png 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-221-300x168.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5<\/strong>:<\/span>\u00a0Under <strong>Axis Options &gt; Minimum &gt;Set the value to<\/strong>\u00a0<strong>0.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-220.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18218\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-220.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"287\" height=\"502\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-220.png 287w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-220-172x300.png 172w\" sizes=\"(max-width: 287px) 100vw, 287px\" \/><\/a><\/p>\n<p>This is how the chart will look:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18265\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"609\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png 609w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM-300x184.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000\">Example 2:<\/span><\/h3>\n<p>In this data table, you have project-wise data including cost, profit, and probability of success.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-211.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18211\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-211.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"516\" height=\"266\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-211.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-211-300x155.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>Using this data, let&#8217;s try to create a 3D Bubble Chart with 3 variables!<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Select the\u00a0<strong>table\u00a0<\/strong>on where we want to create the chart<strong>. \u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-210.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18210\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-210.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"498\" height=\"273\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-210.png 498w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-210-300x164.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> Go to<strong> Insert &gt; Insert Scatter Chart or Bubble Chart &gt; 3D Bubble<em>.<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-225.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18223\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-225.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"796\" height=\"399\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-225.png 796w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-225-300x150.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-225-768x385.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>:<\/span> Add the horizontal and vertical axis title.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18224\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"458\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png 458w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226-300x191.png 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/a><\/p>\n<p>As you can interpret from this chart that even though Project 2 has the maximum profit the chance of success is low. So, it is better to opt for Project 5 which has a high probability of success and high profits as well.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-226.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18268\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-226.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"458\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-226.png 458w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-226-300x191.png 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<div>\n<h2><span class=\"ez-toc-section\" id=\"Formatting_a_Bubble_Chart\"><\/span><a id=\"formatting-a-bubble-chart\"><\/a>Formatting a Bubble Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Formatting a Bubble Chart is vital to <strong>enhance the visual appearance<\/strong> of the chart. You can add colors, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/adding-data-labels-to-an-excel-chart\/\" target=\"_blank\" rel=\"noopener\">data labels<\/a>, axis titles, etc. to make the data really stand out.<\/p>\n<h3>Add Axis Title to the Bubble Chart<\/h3>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Select the Chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18265\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"609\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM.png 609w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/06\/Screenshot-2020-06-25-at-3.14.16-PM-300x184.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> Got to <strong>Chart Design <\/strong><strong>&gt; Add Chart Element &gt;Axis Titles &gt; <\/strong><strong>Primary Horizontal\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-222.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18220\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-222.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"390\" height=\"429\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-222.png 390w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-222-273x300.png 273w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>: <\/span>Type <strong>Age of House<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4563\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-07.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"588\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-07.png 588w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-07-300x204.png 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4<\/strong>:<\/span> Got to <strong>Chart Design <\/strong><strong>&gt; Add Chart Element &gt;Axis Titles &gt; <\/strong>Go to\u00a0<strong>Primary Vertical.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-224.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18221\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-224.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"393\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-224.png 393w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-224-270x300.png 270w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5<\/strong>:<\/span>Type <strong>KMs to City<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4565 size-full\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-09.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"585\" height=\"399\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-09.png 585w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/bubble-chart-09-300x205.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<h3>Add Colors to the Bubble Chart<\/h3>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Right-click on a bubble and click on <strong>Format Data Series<\/strong>.<\/p>\n<div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-234.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18235\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-234.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"465\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-234.png 465w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-234-300x214.png 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> In the <strong>Format Series<\/strong> Panel, Select the<strong> Fill icon<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-235-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18236\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-235-1.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"282\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-235-1.png 282w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-235-1-167x300.png 167w\" sizes=\"(max-width: 282px) 100vw, 282px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>:<\/span> Check <strong>Vary colors by point<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-236.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18237\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-236.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"252\" height=\"495\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-236.png 252w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-236-153x300.png 153w\" sizes=\"(max-width: 252px) 100vw, 252px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4<\/strong>:<\/span> Your desired <strong>Bubble Chart with 3 variables<\/strong> is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-237.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18238\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-237.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"460\" height=\"295\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-237.png 460w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-237-300x192.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><\/p>\n<h3>Add Data Labels to Bubble Chart<\/h3>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong>:<\/span> Select the Chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18224\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"458\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226.png 458w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-226-300x191.png 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2<\/strong>:<\/span> Go to <strong>Chart Options &gt; Add Chart Elements &gt; Data Labels &gt; More Data Label Options<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-227.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18225\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-227.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"412\" height=\"589\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-227.png 412w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-227-210x300.png 210w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3<\/strong>:<\/span> From the Format Label Panel, Check <strong>Value from Cell<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-228.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18226\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-228.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"253\" height=\"490\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-228.png 253w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-228-155x300.png 155w\" sizes=\"(max-width: 253px) 100vw, 253px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4<\/strong>:<\/span> Select the column <strong>Project<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-230.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18228\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-230.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"722\" height=\"228\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-230.png 722w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-230-300x95.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5<\/strong>:<\/span> Uncheck <strong>Y value<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-231-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18230\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-231-1.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"252\" height=\"438\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-231-1.png 252w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-231-1-173x300.png 173w\" sizes=\"(max-width: 252px) 100vw, 252px\" \/><\/a><\/p>\n<p>This is how the chart will look:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-232-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18232\" title=\"Bubble Chart with 3 Variables On A Chart\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-232-1.png\" alt=\"Bubble Chart with 3 Variables On A Chart\" width=\"468\" height=\"309\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-232-1.png 468w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Screenshot-232-1-300x198.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/a><\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Pros_and_Cons_of_using_Bubble_Chart\"><\/span><a id=\"pros-and-cons-of-using-bubble-chart\"><\/a>Pros and Cons of using Bubble Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that you understood how to make a graph with 3 variables (Bubble Chart), it is important to know the pros and cons of using it.<\/p>\n<p><strong>Advantages:<\/strong><\/p>\n<ul>\n<li>It lets you add a third dimension to the data set.<\/li>\n<li>It can be used to depict the relationship between the data sets.<\/li>\n<li>It can be used to convey a lot of information at once.<\/li>\n<\/ul>\n<p><strong>Disadvantages:<\/strong><\/p>\n<ul>\n<li>Too many bubbles can make the graph unreadable.<\/li>\n<li>Overlapping bubbles may create hindrance.<\/li>\n<\/ul>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-milestone-chart-using-excel\/\" target=\"_blank\" rel=\"noopener\">Project Milestone Chart Using Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/overlap-graphs-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to Create Overlay Charts in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/logarithmic-scale-in-an-excel-chart\/\" target=\"_blank\" rel=\"noopener\">Logarithmic Scale In An Excel Chart<\/a><\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;color: #0000ff\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" title=\"How To Use Excel For Dummies\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"How To Use Excel For Dummies\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>, and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a>!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5924 size-full\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A Bubble Chart is an extension of the XY Scatter Chart. Bubble Chart with 3 variables adds a 3rd variable to each point in the XY Scatter Chart. XY Scatter plots x and y values and Bubble Chart plots x values, y values, and z (size) values. Bubble Chart is extremely useful to graphically represent [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Bubble Chart with 3 Variables On A Chart","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,31],"tags":[104,94],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/635"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14685"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}