Bubble chart with RGB

**david_m** · 09-23-2011, 02:47 AM

Hi Forum,
for my work I have the necessity to create a bubble chart that has 3 dimensions; to this bubble chart I have to add the color and the markers.
The problem is that the color is expressed for each coordinate in the form of rgb, but with only one form; while I need to create three markers with different forms.
I do not know how to get out from this problem.
Thanks .

**Andy Pope** · 09-23-2011, 11:31 AM

Given the potential number of colours you will probably need to use code to set the fill colour of each data point.

You provide no detail of the type of different markers.

**david_m** · 09-24-2011, 03:01 AM

I followed the suggestions you gave to me in your answer and I modified the variables as follows:
- Markers (1 = circle, 2 = Triangle, 3 = Star)
- Color (1 = red, 2 = blue 3 = green, 4 = yellow)
If this hypothesis is not possible, I would like to know if you can load the column with the different RGB coordinates on the bubble chart?
Thanks

**Andy Pope** · 09-24-2011, 04:57 AM

You need to add a series for each marker/colour combination.

you might want to use a different shape to triangle as the shape over fills the bubble giving the base a curve.

**david_m** · 09-24-2011, 06:39 AM

Your solution is perfect, but if I want to add a fourth shape (rectangle) how can I do?
Thanks

**Andy Pope** · 09-24-2011, 06:57 AM

First extend formula table to include a new marker set of series data.
Add new series to the chart and assign correct data range via the Select data dialog.
Create 4 new shapes

Then for each new series,
copy one of the shapes
select appropriate series and paste

you may need to set some temporary data values in order to get at least 1 data point for the new series to appear in order to select and paste.