308925_en-US

liliconcom

Re: Lollipop graph

Here is a graph using the Big Class data table, with an added column that has positive and negative random values.

And here is the script

Graph Builder(
 Size( 534, 450 ),
 Show Control Panel( 0 ),
 Variables(
  X( :age, Order By( :Column 6, Descending, Order Statistic( "Mean" ) ) ),
  Y( :Column 6 ),
  Color( :age )
 ),
 Elements(
  Points( X, Y, Legend( 5 ), Summary Statistic( "Mean" ) ),
  Bar( X, Y, Legend( 6 ), Bar Style( "Needle" ) )
 ),
 SendToReport(
  Dispatch(
   {},
   "400",
   ScaleBox,
   {Legend Model(
    5,
    Properties( 0, {Marker Size( 20 )}, Item ID( "12", 1 ) ),
    Properties( 1, {Marker Size( 20 )}, Item ID( "13", 1 ) ),
    Properties( 2, {Marker Size( 20 )}, Item ID( "14", 1 ) ),
    Properties( 3, {Marker Size( 20 )}, Item ID( "15", 1 ) ),
    Properties( 4, {Marker Size( 20 )}, Item ID( "16", 1 ) ),
    Properties( 5, {Marker Size( 29 )}, Item ID( "17", 1 ) ),
    Properties( -1, {Marker Size( 20 )}, Item ID( "Mean", 1 ) )
   )}
  )
 )
);

Lollipop graph

Is it possible via GraphBuilder to make  a lollipop plot? See example I've posted. I know you can get something akin to this when looking at time series data (under the time series platform). The control chart very nearly does this, too, but it is obviously to be used for other sorts of analyses, and the lines are not drawn directly below the points. What I want is for the point plotted to have a line drawn above or below it that connects it to the mean (to emphasize deviation from the mean). I feel like all the elements for making such a plot are there!

 

GraphicsRe: Lollipop graph

Jim, 

Wow, thanks so much. That's exactly what I wanted. I didn't even think to integrate a "needle" bar graph with a "mean" point sitting on top, but for those who want to do it all through GraphBuilder (i.e., without scripting), that's how you do it. If you additionally want to interactively size the dots in proportion to the response variable of interest, simply drag the parameter to the "size" drop zone on GraphBuilder. I am attaching my first lollipop plot as an additional example. Thanks so much and hopefully this may help others who stumbled across this post. 

Re: Lollipop graph

Another approach, requiring more JSL for custom Markers.

Using an image for the marker. Use As Marker will show up in other graphs.

There are two Roberts in Big Class; the Needle is the average. The points are shown for both.

dt = Open( "$sample_data/big class.jmp" );
dt << New Column( "height-mean", formula( height - Col Mean( height ) ) );
dt << Color by Column( :Age );

// build the floating round marker...
dt << New Column( "marker",
 expression,
 formula(

  box = (Graph Box(
   // make a small drawing space 100x100 pixels, scaled from -1 to 1. Black background becomes transparent below
   framesize( 100, 100 ), X Scale( -1, 1 ), Y Scale( -1, 1 ), <<BACKGROUNDCOLOR></BACKGROUNDCOLOR>

 

Re: Lollipop graph

Love it!

Re: Lollipop graph

You can actually reproduce this interactively (albeit less beautifully) by increasing the marker size, labeling by height, then reducing the marker transparency (I halved it). In this example, I just colored by gender. 

The only issue I can see is that, if you want to have the icon sizes scale with something (like age in this second example) AND have the labels (for height in this example), you may need to manually drag the labels around so that they don't fall in a weird place (see second plot, in which case I manually changed the location of Clay and Danny's labels). There might be a work-around though (I tried messing around with the marker sizing options and failed).  

Re: Lollipop graph

Nice! You can probably order the marker segments so the numbers draw on top of the circles. And you might be able to make the numbers be markers as well (UseForMarker attribute on a column). That would center the number in the circle. Avoiding the JSL in my example would be a good choice; it is pretty slow to make a graph and take its picture for each data point.

Re: Lollipop graphWhen I run this under v13.2.1 , the lollipops markers are very small. So small the embedded number isn't visible. How can I increase the size of the markers?Re: Lollipop graph

The "<

Re: Lollipop graphThanx.