Bubble Chart Excel Definition. Apr 05 2011 Take a look at the bubble chart that we created using the data from the first Excel 3D example. Create bubble chart by Bubble function a basic bubble chart with bubbles in the same color.
Each bubble is a different color and the size of the bubble illustrates the third value. Like a traditional scatter plot you can show different metrics on the x-axis and y-axis of the chart. Each dot in a bubble chart corresponds with a single data point and the variables values for each point are indicated by horizontal position vertical position and dot size.
Create bubble chart by Bubble function a basic bubble chart with bubbles in the same color.
Then you can visualize a third dimension of data through the scale of the bubbles. These charts are best when you have mixed data or want to emphasize different types of information. The same as Example 1 but the bubble size variable has been removed so now it is displayed as a scatter chart. With three values you get bubble chart.
