Bubble chart with 5 dimension + label

**Antonino** · 11-03-2010, 08:03 AM

Hi Andy,

I would like to know if you can include the legend in the bubble plots using a VBA code.
In particular, the text that is contained in the 6 different cells of the range (R1: W1) should be linked to the 6 different colors of the matrix (R2: W7)
Could you help me?

Thanks
Antonino

I attach a dataset

**Andy Pope** · 11-03-2010, 08:23 AM

If you enable the legend you will see each point has an entry. This is because of the unique formatting applied to each series.

If you then use the Source data dialog to add 5 dummy series the legend will then display the names of the new series.

But how will the legend relate to the data points, seeing as each data point is unique in shape and colour?

**Antonino** · 11-04-2010, 04:56 AM

Hi Andy,
probably in the previous mail, I did not explain myself clearly.
The legend that I would like to create should not be linked to the data-source, but I would like that it could pick up individually the 6 shapes on the worksheet and then I could concatenate a text description.
The result that comes out with vba should generate a sort of static image that shows to the reader that every point with that shape and that color belongs to category1, category2, etc.
Thanks
Antonino

**Andy Pope** · 11-04-2010, 05:51 AM

I did not say link the extra data series to any actual data. But makes no odds as when you add extra series an change their markers the legend adds a bubble to the composite picture in the legend.

The simplest thing is to create the legend using shapes and textboxes and group them.

**Antonino** · 11-17-2010, 06:16 AM

Hi Andy,

on the variable Z2 (color) of the file (750713b.xls) I have created on the range (F2: F51) 40 random numbers between 1 and 20.
On this range I have applied the rule of conditional formatting of two colors (max=red and min = blue).
This is my question: Is it possibile, creating a new Sub, to transfer to the 5 forms the color corresponding to the cells included in the range F2: F51?

bye

Antonino