Monday, March 15, 2021

Bubble chart in Excel

 Bubble chart in Excel:

        Bubble chart show the relationships between sets of values.

        Bubble chart compare at least three sets of values or pairs of data.

        You can use it when you have a third value that can be used to determine the relative size of the bubble.

Process of creating a bubble chart in Excel:

  • Select your data range B3:D6 to create bubble chart. 










  • Go to insert tab ➤ charts group ➤ select insert scatter or bubble chart ➤ select 3D Bubble chart.

















  • Now 3D Bubble chart immediately appears on your excel sheet.










  • Click on chart title to edit it.
  • Click on any bubble on your chart ➤ right click on a bubble➤ click on format data series.

  • A format data series panel appears ➤click on the paint bucket tool ➤ select vary colors by point.


































  • Now your chart looks like the below.






















  • Here you can change the chart style from design tab
  • Go to design tab select any chat style from chart style group.









Result:












  • To add data labels click on the + icon on the right side of chart ➤click on data label ➤go to more option.

















  • Now Format data labels panel appear.
  • Here you can select bubble size, show leader lines which you want to add in your chart.
  • Also you can add label position center, left, right, above or below of your bubble.
































  • Now the result shows like the below.....























  • To add legend click on + icon on the right side of your chart ➤ click on legend.


















  • Result appears showing legend like this....
























  • To change the shape of data labels right click on the data label of your chart ➤ change data label shapes➤ select any shape



























  • Now data labels appears with your selected shape. Slightly move them to fix to correct position.
























In this process you can create a bubble chart in excel.

No comments:

Post a Comment

Bubble chart in Excel

  Bubble chart in Excel:           Bubble chart show the relationships between sets of values.          Bubble chart compare at least three ...