Table of Contents
In order to color a bubble chart in Excel based on its value, you can follow these steps:
1. Select the bubble chart you wish to color.
2. Click on the “Format” tab in the chart toolbar.
3. In the “Current Selection” group, click on the “Format Selection” option.
4. A new window will appear. In this window, click on the “Fill & Line” tab.
5. Under the “Fill” section, select the option “Solid Fill”.
6. Then, click on the button next to it to select a color.
7. In the same window, click on the “Size & Properties” tab.
8. Under the “Size & Properties” section, click on the “Size” option.
9. In the “Size” drop-down menu, select the option “Value”.
10. This will automatically color the bubbles in the chart based on their value.
11. You can further customize the colors by selecting different color schemes or manually choosing colors for each bubble.
12. Once you are satisfied with the colors, click on “Close” to apply the changes.
By following these steps, you can easily and effectively color your bubble chart in Excel based on its value, making it more visually appealing and easier to interpret.
Excel: Color a Bubble Chart by Value
Often you may want to color the points in a bubble chart in Excel based on a value or category, similar to the plot below:
Fortunately this is easy to do in Excel.
The following step-by-step example shows exactly how to do so.
Step 1: Enter the Data
First, let’s enter the following dataset that contains information about points, assists, and years in the league for various basketball players:
Suppose we would like to use this data to create a bubble chart using Points as the x-values, Assists as the y-values and Years as the size of the points.
Step 2: Format the Data
Before we can create a bubble chart, we must first format the data in a specific manner.
First, we’ll enter the unique values for each team name along with the y-values and z-values to be used in the plot:
Next, type the following formulas into cells F3 and G3:
- F3: =IF($A3=F$1, $C3, NA())
- G3: =IF($A3=F$1, $D3, NA())
Next, highlight cells F3 and G3.
Click and drag these formulas to the right until you hit cell K3.
Then click and drag the formulas down until you hit cell K11:
Step 3: Insert the Bubble Chart
Next, highlight the range B3:B11. Then, hold Ctrl and highlight every cell in the range F3:K11.
Then click the Insert tab along the top ribbon and then click Bubble within the Charts group:
The following bubble chart will appear:
Each of the players from the dataset are shown in the bubble chart with each bubble colored based on the team name.
Step 4: Modify Appearance of Bubble Chart (Optional)
Lastly, feel free to modify the colors, point sizes, and labels to make the plot more aesthetically pleasing:
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How can I color a bubble chart in Excel based on its value?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-color-a-bubble-chart-in-excel-based-on-its-value/
stats writer. "How can I color a bubble chart in Excel based on its value?." PSYCHOLOGICAL SCALES, 21 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-color-a-bubble-chart-in-excel-based-on-its-value/.
stats writer. "How can I color a bubble chart in Excel based on its value?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-color-a-bubble-chart-in-excel-based-on-its-value/.
stats writer (2024) 'How can I color a bubble chart in Excel based on its value?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-color-a-bubble-chart-in-excel-based-on-its-value/.
[1] stats writer, "How can I color a bubble chart in Excel based on its value?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I color a bubble chart in Excel based on its value?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.