cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
djhanson
Level V

Graph Builder - bar chart how to show summary table?

Hi, using Graph Builder I'm making a bar chart with a legend.  Each Xvalue bar shows a breakdown by the legend categories (so they add up to a sum for the total bar of course).

Question: is there any way to make a summary data table below it displaying the X value by legend breakdown? 

I'm thinking by using Table Box and its elements.  I've tried various things even with Summarize, but it's not as simple as it looks.  Yet, the Graph Builder displays the breakdown fine, I'd just like to display the values of each of the Legend breakdowns by Xvalue below the chart.  thx... dj

Graph Builder(

    Show Control Panel( 0 ),

    Variables( X( :Xvalue), Y( :Yvalue ), Overlay( :Legend ) ),

    Elements(

    Bar(

         X,

         Y,

         Legend( 6 ),

         Bar Style( "Stacked" ),

         Summary Statistic( "Mean" )

         )

  ),

  SendToReport( Dispatch( {}, "Xvalue", ScaleBox, {Rotated Labels( "Automatic" )} ) )

);

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Graph Builder - bar chart how to show summary table?

The "Caption Box" option (new in JMP 10 I think) may provide what you want.

Example:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << Graph Builder(

  Show Control Panel( 0 ),

  Variables( Y( :height ), Group X( :age ), Overlay( :sex ) ),

  Elements(

  Bar( Y, Legend( 6 ), Bar Style( "Stacked" ), Summary Statistic( "Mean" ) ),

  Caption Box(

  Y,

  Legend( 7 ),

  X Position( "Right" ),

  Summary Statistic( "Mean" ),

  Y Position( "Bottom" )

  )

  ),

  SendToReport(

  Dispatch( {}, "", ScaleBox, {Rotated Labels( "Automatic" )} ),

  Dispatch(

  {},

  "height",

  ScaleBox,

  {Min( -20 ), Max( 150 ), Inc( 25 ), Minor Ticks( 0 )}

  )

  )

);