What is Bubble Chart Visualization in Excel
A bubble chart, an extension of a Scatter plot, is widely used to depict correlations between three or more numerical variables. A single data point is represented by each bubble in a chart. Each bubble’s value is represented by 1) its horizontal location on the x-axis, 2) its vertical position on the y-axis, and 3) its size. The color of the bubble or its movement in animation can sometimes symbolize additional dimensions.
By adding a third numeric column that determines the size of the data points, you may change the Scatter Chart visualization to the Bubble Chart visualization.
Scatter and Bubble Chart Visualization in Excel
Scatter Charts and Bubble Charts display many related data in one Chart. In both of these charts, the X – axis displays one numeric field and the Y-axis displays another. It helps to specify the relationship between two values for all the items in the chart easily. In Bubble charts, a third numeric field controls the size of the data points.