Bubble Chart - Colors of the bubbles

**nadine123** · 10-31-2013, 05:21 AM

Hello everybody,

I created a bubble chart diagram in excel 2013 about the sellings of printing paper.

x-axis : sheets per pack
y-axis : price per sheet
size of bubbles: Sales of the different products

Now i want to color each bubble, depending on which printing company belongs to the bubble.
I want to have it automatically so that it's possible to change the data in the table without manually coloring each bubble seperately.

Thanks in advance.

**Andy Pope** · 10-31-2013, 05:25 AM

You need to use multiple data series and populate each one from original data set using formula

**nadine123** · 10-31-2013, 05:29 AM

okay, can you please describe it a bit more specific?

**Andy Pope** · 10-31-2013, 05:30 AM

can you post example workbook so the description is relevant to your data.

**nadine123** · 10-31-2013, 05:49 AM

Brand sheets cpp Sales EUR Color

CANON 100 0,10 40.000 red
AVERY 50 0,10 25.000 orange
AVERY 100 0,09 25.000 orange
AVERY 50 0,10 23.000 orange
EPSON 70 0,06 15.697 blue
AVERY 60 0,10 14.018 orange
SIGEL 100 0,09 12.666 green
SIGEL 24 0,20 9.712 green
SIGEL 72 0,15 9.387 green