Formatting a bubble chart

[#1]

I am trying to format a bubble chart to have all bubbles the same color (red or black) and the color should be transparent. How to do this?

[Oleg_Troyansky]

To make all the bubble have the same color, you should modify the "Background Color" attribute for the Expression. In order to make the color partially transparent, use function ARGB. For example:

=ARGB(100,0,0,0)

will product semi-transparent black bubbles.

regards,

Oleg

[sathishkumar_go]

Hi Matthias,

Please find the attachements. I hope it ll help for u.

and also check that bubble color all r in blue. Same think u put (Red or black) it ll come.

-Sathish

[#4]

Hi Oleg,

Thanks for your answer, I have tried this before it dose not work??

[sathishkumar_go]

HEY

I think u r not giving = (before AGRB(100,0,0,0))

[#6]

Hi Sathish,

no, unfortunately no change, I can not remove the " Multicoloured" flag from the properties??

[sathishkumar_go]

Hi

go to chart proprties -> colors

Colors1-6 Colors7-12 colors12-18 tabs r there?

u just copy red color and paste in to all tabs

then it ll work fine

-Sathish

[#8]

Hi Sathish,

I was following your suggestions and I found a funny think after changing everything and applying the background colour the colour of the legend symbols changed and not the colour of the bubbles in the graph??

[#9 · Accepted solution]

Hi solved the problem, the solution is that you only alowed one Dimension.