For that, reach the Layout tab, select Axis Title, then selects “Primary Horizontal Axis Title.” After that, Select “Title Below Axis”. Step 5 – Now, we have to give titles to the X & Y-axis. Now select the chart title on the chart, press =, then select “Countries” and press Enter. Step 4 – We must add Chart Title and label to our Bubble Chart.įor that, we have to reach the Layout tab and click “Chart Title” and “Above Chart” to place the title above the chart.Īfter Adding the Chart Title, our Chart looks like this. Here also, you must change the option from Auto to fixed in “Axis Options” and set the value to 5 as the base figure for X-axis (Birth Rate). Once you click the “Format Axis”, you will get the below pop-up. Then right-click and select “Format Axis”. Select the X-axis with a single click of the mouse. Step 3 – We need to format the X-axis just like the Y-axis. I have taken a base figure 50 for Y-Axis (Life Expectancy). ![]() You must then change the “Axis Options” from Auto to Fixed, as shown below. Once you click on the “Format Axis”, the following pop-up will open. Then we will press the right click to get the option and select the last one, “Format Axis”. First, we will select the Y-axis by clicking on it. Now we need to format this Bubble chart for better understanding and clarity. Step 2 – Once you have clicked the “Bubble” option in the drop-down, you will see the Bubble chart created below. I have selected the Bubble option for the below examples. Adjacent to that, you also have Bubble with a 3D effect option. You will see Bubble in the dropdown select Bubble. Then go to Insert Tab < Other Charts, click on it. Step 1– Select /create data to create the chart.īelow is sample data showing various countries’ birth rates, Life expectancy, and GDP. We used the example sample worksheet data for the Bubble chart in Excel. You can download this Bubble Chart Excel Template here – Bubble Chart Excel Template Example #1 ![]() Let us now see how to create Bubble Chart in Excel with the help of some examples. They are mostly used in business, social, economic, and other fields to study the relationship of data. ![]() We can show the relationship between different datasets. Thus, the third value determines the size of the Bubble.īubble Charts are available in Excel 2010 and other versions of MS Excel. If you also wished to express the country’s GDP, you could proportionally enlarge or shrink each plotted data point in the form of a Bubble– to simultaneously highlight the relationship between birth rate and life expectancy but also to highlight the GDP of the countries. This is useful for showing the population or regional capacity data.Įxample: A typical XY Scatter chart might be used to display the relationship between birth rate and life expectancy at birth, with the county as the unit of analysis. The higher the data point value, the bigger the bubble will be, and it will eventually be seen at the top of the chart similarly, a lower value will have a small bubble near the bottom Y-axis. Bubble chart in Excel, as the name suggests, in the chart, we represent the data points with the help of bubbles. – Project management to compare the risk and reward among projects.It is categorized as a part of the Scatter or Bubble chart option in the Insert menu tab. Hence proper care must be taken so that the change in the area is liner by mathematically altering the change in the radius according to the variables value. Human visual system can feel the difference in the size, but with change in the radii (3rd dimension or variable), the corresponding change in the area is non linear. Bubble charts can facilitate the understanding of social, economical, medical, and other scientific relationships.īubble chart is often considered as an extension of scatter chart with the size & color factor also being introduced. The first two dimensions are visualized as coordinates, the 3rd as color and the 4th as size. What is Bubble Chart ? A bubble chart is used to visualize a data set with 2 to 4 dimensions.
0 Comments
Leave a Reply. |