Excel Bubble Diagramm. Do not select the row or column headers. 1 click fill tab and check solid fill option then drag the transparency slider to the bubble transparency you need.
2 click border color tab check solid line option and select the color line you need. However in some special cases you may want to adjust the bubble size of the bubble chart for better showing the data. Create a blank workbook or worksheet.
Bubble chart in excel can be applied for 3 dimension data sets.
The larger the bubble the larger value it represents. It adds one more dimension to the normal scatter chart. In the select data source dialog add series by. Right click the inserted blank chart and click select data from the context menu.
