Once you have selected the Bubbles, press right-click and select “Add Data Label”.Įxcel has added the values from life expectancies to these Bubbles, but we need the values GDP for the countries.įor that, we need to press = and select the GDP relating to the country showing Life expectancy.Įxample: Select the topmost Bubble, which shows 83.91(Life Expectancy) of India we need to change it to the GDP of India. For that, we have to select all the Bubbles individually. Step 7 – Adding data labels to the chart. The Y-axis is now labeled as Life Expectancy. Now select the “Axis Title”, press = and then select “Life Expectancy”, press Enter. You will see “Axis title” to the Vertical axis. Step 6 – We will give the title Y-axis in the same manner. Now select the “Axis Title”, press = and then select Birth Rate, press Enter. Once you have clicked the “Title Below Axis”, you will see “Axis title” below the horizontal axis. 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 – Now, we have to add Chart Title and label to our Bubble Chart.įor that, we have to reach the Layout tab and then click “Chart Title”, then “Above Chart”, to place the title above the chart.Īfter Adding Chart Title, our Chart look like this. Here also, you have to 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 – Now, we need to format the X-axis, just like the Y-axis. I have taken a base figure of 50 for Y-Axis (Life Expectancy). You then have to change the “Axis Options” from Auto to Fixed, as shown below. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |