cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
TWE
TWE
Level III

Pie of Pie chart

Hi,

 

is there a way to generate a pie chart (pie or bar of pie chart) like the following one?

https://www.officetooltips.com/excel_2016/tips/creating_pie_of_pie_and_bar_of_pie_charts.html

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Pie of Pie chart

I don't think that these composite plots are built-in to JMP, but you can create something similar by combining reports.  It might be helpful to create an ID column to designate which rows should be combined together.  For the effect of pie-in-pie, this could mean copying your category column and changing some of them to "Other", or it could be more general if there are other meaningful groups.

 

Once you create two graphs (one using the ID column, one using the full category columns), you can use Combine Windows to merge them together, and choose the ID column as a Selection Filter.  Below is what I get using age as the grouping column with the Big Class sample data.  With 16-year-olds selected on the left, the individual 16's are shown on the right.

 

piefilter.png

 

One advantage of using selection filters is that the behavior is dynamic - you can select any category on the left and the plot on the right will update.  You can also select multiple categories, so if you want to see 12- and 13-year-olds in one plot, you can select them both.  You are also not limited to Pies and Bars - you can use any JMP reports that work for your data.

 

There are more selection filter examples in Using Selection Filters in JMP 12 .  This article uses Application Builder to create the report, but starting in JMP 13 the functionality is built directly into Combine Windows.

 

View solution in original post

5 REPLIES 5

Re: Pie of Pie chart

I don't think that these composite plots are built-in to JMP, but you can create something similar by combining reports.  It might be helpful to create an ID column to designate which rows should be combined together.  For the effect of pie-in-pie, this could mean copying your category column and changing some of them to "Other", or it could be more general if there are other meaningful groups.

 

Once you create two graphs (one using the ID column, one using the full category columns), you can use Combine Windows to merge them together, and choose the ID column as a Selection Filter.  Below is what I get using age as the grouping column with the Big Class sample data.  With 16-year-olds selected on the left, the individual 16's are shown on the right.

 

piefilter.png

 

One advantage of using selection filters is that the behavior is dynamic - you can select any category on the left and the plot on the right will update.  You can also select multiple categories, so if you want to see 12- and 13-year-olds in one plot, you can select them both.  You are also not limited to Pies and Bars - you can use any JMP reports that work for your data.

 

There are more selection filter examples in Using Selection Filters in JMP 12 .  This article uses Application Builder to create the report, but starting in JMP 13 the functionality is built directly into Combine Windows.

 

TWE
TWE
Level III

Re: Pie of Pie chart

Thanks, this should work!
Mo
Mo
Level III

Re: Pie of Pie chart

Question: how did you get the thicker line around the one segment (to highlight)?

Re: Pie of Pie chart

The pie segment is outlined based on the preference for how to draw selected areas:

 

FillPref.png

 

I have attached PieFilter.jmpapp if you would like to try it out.  The app is configured to automatically run on $SAMPLE_DATA/Big Class.jmp.

nascif_jmp
Level VI

Re: Pie of Pie chart

Since JMP 15.0, you can accomplish the same task using Graphlets and their pre-configured presets.

By pinning the hover labels with pie charts for different slices, you can also compare the result of different paths of your drill-down analysis (and you can launch these pie charts as new graphs for an even better comparison).

The screenshot below shows an example:

pie_of_pie.PNG