Bubble chart with 5 dimension + label

I would like to ask you if on a bubble chart we can manage 5 variables and a label field
In particular, the variables are as follows:
1. Name (Label)
2. X (first variable)
3. Y (second variable)
4. Z (size)
5. Z1 (shape code)
6. Z2 (colour code)

The variables X, Y, Z are managed by the Bubble chart but the other two variables:

a) z1 should manage the shape of z;
b) z2 should vary the colour of the indicator Z;

I attach a dataset

But if I manually change the field ‘s values z1 and z2 can I do the automatic update of the bubble plot?
By
Antonino

Hi Andy,

the macro works well on the data set that I previously sent to you; but I have still a problem:
the information that the bubble plot manages come from a source that transmits them in real-time.

I would like to ask you (because I do not not completely know VBA) if the update of the six variables on the bubble plot could take place automatically.

I tried to play on the new dataset (A2: F51) my problem:
1. Name (Label)  RANDBETWEEN [(1-100) & string]
2. X (first variable) )  RANDBETWEEN (1-100)
3. Y (second variable)  RANDBETWEEN (1-100)
4. Z (size)  RANDBETWEEN (1-100)
5. Z1 (shape code)  RANDBETWEEN (1-5)
6. Z2 (color code) as follows:
IF Shape = “square” =1 associed Color1 = red;
IF Shape = “triangle” =2 associed Color2 = blue;
IF Shape = “star” =3 associed Color3 = green;
IF Shape = “cilinder” =4 associed Color4 = yellows;
IF Shape = “oval” =5 associed Color5 = purple;

I hope in your help

bye-bye


Antonino

P.S.: I would like to ask you a curiosity: but the color of the shapes can be associated with the range of variation of the variable color (z2) according to a color that goes from red to blue depending on its range of variation of z2?
If the answer is yes on which part of the code should I intervene?

Hi Andy,
I did a test with 5 cases, but it seemed that the bubble plot does not do the update of the field label, shape and colors.
what can I do?
bye-bye
Antonino

I inserted the new code on the sheet.
I made a new test range reduced (A2: F6), but there is the problem of update of the fields.
bye-bye
A.

1) F2 the cursor goes into the cell
2) F3 see attached image

see attached image

With the copy and paste update the plot is ok!...
then we are on a dead end .....or is there another alternative with another event to change the cells?

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

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

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