In Excel, you can create a bubble chart with individual bubble colors for different brands by following these steps:

Data Preparation:
- Ensure your data is organized in a table with the following columns: X-axis values, Y-axis values, Bubble size values, and Brand (for individual bubble colors).
Insert a Bubble Chart:
- Highlight your data table, including headers.
- Go to the "Insert" tab in Excel.
- Click on the "Bubble Chart" option in the "Charts" group.
- Select the "3-D Bubble" chart.
Initial Bubble Chart:
- Excel will create a basic bubble chart.
Set Bubble Colors by Brand:
- To set individual bubble colors by brand, you need to map each brand to a specific color.
Add a New Column for Color Mapping:
- In your data table, add a new column for color mapping. In this column, assign a color code or name to each brand. For example, you can use values like "Red," "Blue," "Green," etc., or use hexadecimal color codes.
Map Bubble Colors:
- Click on one of the bubbles in your chart. This will select all bubbles.
- In the "Format" tab that appears when the chart is selected, go to "Shape Fill."
- Choose "More Fill Colors."
Color Mapping Dialog:
- In the "Color" dialog box, go to the "Custom" tab.
- For each brand, select the color you assigned in the color mapping column of your data table.
- Click "OK" for each brand to apply the color.
Individual Bubble Colors:
- Each bubble should now have an individual color based on the mapping you provided.
Legend (Optional):
- If needed, you can add a legend to the chart to explain the color-coding.
Format as Desired:
- Customize the chart title, axis labels, and any other formatting options as needed.

By following these steps, you should be able to create a bubble chart in Excel with individual bubble colors based on brands. Ensure that the color mapping in your data table matches the colors you choose in the chart to achieve the desired result.

project-7