Excel Bubble Diagramm. In the select data source dialog. Disadvantages of bubble chart in excel.
Attractive bubbles of different sizes will catch the reader s attention easily. When you create a bubble chart in excel you do not select the labels as excel would not know what to do with them. Bubble chart in excel might be difficult for a user to understand the visualization.
Out of those three data sets used to make the bubble chart it shows two axis of the chart in a series of xy coordinates and a third set shows the data points.
Do not select the row or column headers. Right click at the blank bubble chart and click select data from the context menu. The larger the bubble the larger value it represents. Create a blank workbook or worksheet.