While creating a bubble graph I ran into two issues.

Firstly greater bubbles starting to show over smaller bubbles, thus making the smaller invisible. It appears the bubbles are ordered in line with the legend (BY field) showing in alphabetical order. As an additional BY (eg BY TOTAL HIGHEST REVENUE NOPRINT) is not allowed in this type of chart, I am hoping somebody can help me. Is there a way to get the smallest on top keeping the Legend available?

Secondly I learned that the smallest Bubble size is set and the others are scaled against that. With extreme values ranging from 1 to 1.000.000 the largest ones are filling up the entire screen. By changing the values to a percentage of the total without decimals the scaling is only 1 to 100, but still this gives strange results. Is there a way to fix the size of the largest one instead of the smallest?

Regards Jasper

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Jasper,
What WF version and what output format are you working with?

If you are working with JSCHART format in WF8009 or below, you can set transparency for each series(bubble) so that smaller bubbles will show up behind the bigger bubbles.
And also set the maximum bubble size, so that much bigger bubbles will not take up the entire screen.
Here is a simple example where I set the transparency for Italy(3rd series):

  
GRAPH FILE CAR
SUM CAR.SPECS.WIDTH
CAR.SPECS.LENGTH
CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 0
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setUseDefaultBubbleMarker(false);
setLegendPosition(2);
setFillColor(getSeries(2), new Color(136,144,151,200));
*END
*GRAPH_JS
bubbleMarker: {maxSize: '20%' },
*END
ENDSTYLE
END

-RUN

In WF8103 or above you would be able to set transparency for all bubble markers, by adding the following code to *GRAPH_JS section:

 
series:[
{series: 'all', marker: {shape:'circle',fillEffect: '50%'}}
],

Hope this helps.

Thanks.
Nick

Hi Nick,

Thank you for you input.

Max Bubblesize is working, although I could not see it at first due to an old explorer version (8).
As for the transparancy setting, my Legend (BY) is flexible (country/make/color/etc etc), so I do not know in advance the number of series that will need to show.

As for now thank you for the max size, it already reduces the need for transparancy.

Jasper