Tip to use bubble size to show the 3rd dimension
: In the
previous tutorial, we focus on adding a lot of labels into xy-plot
; in the following tutorial,
we hellp you to use bubble size to show the 3rd dimension.
When to use a Bubble chart
Bubble charts are often used to present financial data. Use a Bubble chart when you want specific values to be more visually represented in your chart by different bubble sizes. Bubble charts are useful when your worksheet has any of the following types of data:
• Three values per data point
Three values are required for each bubble. These values can be in rows or columns on the worksheet, but they must be in the following order: x value, y value, and then size value.
• Negative values
Bubble sizes can represent negative values, although negative bubbles do not display in the chart by default. You can choose to display them by formatting that data series. When they are displayed, bubbles with negative values are colored white (which cannot be modified) and the size is based on their absolute value. Even though the size of negative bubbles is based on a positive value, their data labels will show the true negative value.
To create the bubble charts, you need to have the data ready, specifically:
1) Put the 3 columns in order: x-column, y-column, bubble size column
(if in different order, then wrong bubble size chart)
2) Don't select the column header at the beginning to create the chart.
At the very end, when you need to add some label to some particular bubble, click the bubble, then type "=A2",
(Say A2 is the cell that contains the label you want).
(3) If you have two bubble charts(A, B), but on the different scales.
By default, the largest bubble corresponds to the largest values in that data series.
(the 2 largest bubbles from those 2 charts should have the same size, but different values).
You want to apply the same scale(bubble size) on those 2 charts(so you can compare the size on those 2 charts),
then you can just add some extra cell(usually copy the largest of the two charts) to the charts with the relatively smaller cell.
After creating the bubble chart, fill the largest bubble and null and null boundary.
Continue to Use a Panel Chart
Back to Add labels to xy scatter plot
Excel Analytics Home