topic Re: pie graphs+heat maps in Discussions

pie graphs+heat maps

abmayfield — Tue, 13 Aug 2019 15:06:19 GMT

Hello everyone,

As a marine biologist, I recently stumbled across a visual presentation of coral reef data that I really like (see attachment). In it, you will see various pie graphs in which the individual wedges are essentially heat maps to show relative levels of certain parameters. I would like to adapt this for my own research, and I THINK it cn be done with Graph Builder, though not as a heat map, per se. Here is my idea: say I want four pie wedges representing four response variables (A, B, C, and D). The size is unimportant, so I will give each a value of 0.25 so that they occupy equal areas. I realize I can overlay color, so I created a "color" column and assigned values for the four response variables, but then my graph didn't change accordingly. I tried value coloring and labeling, but no luck. I feel like I just set up my table wrong! Any suggestions?? Thanks!

Re: pie graphs+heat maps

abmayfield — Tue, 13 Aug 2019 18:19:40 GMT

I am still stumped, so I thought I'd attach the actual data file. Basically, I want to put the last five columns into a pie graph in which the wedge colors reflect the colors in the cells (wrapped by sample number). I am beginning to think this may not be possible with Graph Builder.....

Re: pie graphs+heat maps

John_Powell_JMP — Thu, 18 Dec 2025 13:43:59 GMT

With the columns of interest stacked, a custom map can be used to acheive the visualization you're looking for.

Here's an example on JMP public using the data you've supplied.

You can find the custom map and modified data table at:

https://public.jmp.com/packages/5d5aa110f40f010268e63cf4

~John

Re: pie graphs+heat maps

SDF1 — Mon, 19 Aug 2019 14:42:00 GMT

Hi @John_Powell_JMP,
I'm really interested in trying my hand at this to see if I could adapt it to some of the reporting my business does.
You mention that you stacked by the columns of interest, but which ones are those? I downloaded the data table, but can't figure out which columns are needed to stack. And, does JMP automatically generate the pie chart as a sectional "bullseye", or is this a separate setting. I haven't seen one like this before. It's a nice visualization, and new to me, which is why I'm curious about it.

Thanks!,
DS

Re: pie graphs+heat maps

John_Powell_JMP — Mon, 19 Aug 2019 15:17:44 GMT

I stacked columns named: Sym GE HMS, host GE HMS, colony color, variability, and summed aberrancy index . In the table attached to the JMP Public post, they are now under the column named Responses with the label for each response(the old column names) in the Label column.

JMP doesn't automatically create sectional "bullseye" charts. There are a few steps involved:

I created the custom map shape files provided with the JMP Public posting that define the sections and bullseye.
In Graph Builder, I dragged the Label column to the Shape role (bottom left), which displayed the outline of the custom shape.
To get the colors applied, I dragged the Responses column to the Color role(on the right). This fills in the shape with the average responses for each sector.
To separate out each sample, I dragged the sample number column into the Wrap role(top right).

I can't take credit for the nice visualization idea. It came from the original poster.

I'm glad to see it may help you out too.

~John

Re: pie graphs+heat maps

SDF1 — Mon, 19 Aug 2019 19:09:32 GMT

Hi @John_Powell_JMP,

Thanks for your quick and clear reply. Before I had received your response, I re-read the original post and realized I skimmed it too quickly and noted the mention of the last five columns.

I then downloaded your content from JMP Public and looked more into the details there and noticed the reference to the map shape for the label column properties. I hadn't explored that possibility in the past, so have been reading a bit and experimenting with your maps. Very cool!

I was hoping to maybe also overlay in the background the longitude/latitude position of where the data was collected on the world map -- like in the example from the original poster. I think that's beyond what can be done in graph builder, though; however it would be cool. It is a nice visualization idea. Yes, I can definitely see how that be useful for my work. I tested it out on some of our data, and all I have to do is adjust the Name for the shape ID, and it works. Very nice, thank you!

By the way, I would mark your post as a solution (at least for the pie graph), but I don't think I can do that. Can JMP do both the pie graph and contour (or heatmap) as the original poster was hoping for?

Thanks!,
DS

Re: pie graphs+heat maps

John_Powell_JMP — Thu, 18 Dec 2025 13:49:34 GMT

Thanks for your kind words @SDF1 .

You're right that I didn't completely answer the part about overlaying theses graphics over a background map.

Overlaying on a map would require a different mechanism, like using the script in the Customize dialog:

There are some sample scripts provided:

You can find information on the Customize feature here:

https://www.jmp.com/support/help/14-2/customize-graphical-elements.shtml

Here's a small example using circles:

Bivariate Fit of weight By height | JMP Public

Example of a Customize graphics script.

https://public.jmp.com/packages/5d56a884f40f010268e63cb3

With some effort and study of the graphics functions available in JSL (see: https://www.jmp.com/support/help/14-2/graphics-functions.shtml#2616158 ), more complex, color coded shapes are possible.

~John

Re: pie graphs+heat maps

SDF1 — Tue, 20 Aug 2019 14:06:09 GMT

Hi @John_Powell_JMP,

Thanks for the additional information. I've bookmarked this discussion so I can have it on file and then also go back to re-read the additional info you sent.

Sorry, I worry I might have not explained what I meant about marking your post as a solution -- I don't think I can because I wasn't the original poster (and therefore don't have that option), not because you didn't address the heatmap. My apologies if it read that way -- I went back and re-read it, and it does kind of sound like I was saying it that way (not good on my part).

I'm familiar with JSL and use it for many other things, but have not attempted using it for customized graphing like this, so this will be a new area for me to learn!

Thanks!,
DS

Re: pie graphs+heat maps

abmayfield — Tue, 20 Aug 2019 14:15:23 GMT

Wow! This is great. Thanks for all the help and info John. I had no idea that the custom map feature existed, so I went down that "rabbit hole" for a day or two just thinking about all the cool ways I could use that to plot data onto traced images of the corals I study (sadly, though, I rarely take tons of samples WITHIN the same colony, though it's definitely a backburner project idea, and this would be a cool way to display the findings).

I think having the ability to plot data onto whichever kind of shape, image, etc. is definitely a JMP feature that more people should know about, and I suggest having it be an actual feature within the package in the future (rather than as an add-in, though the add-in works fine for the time being).

To DS: I had actually just thought about making my pie graphs and maps in JMP (plotting data on maps is pretty straight-forward with JMP once you've done it a time or two), then using Adobe to make the types of figures shown in my original post, but JMP has ways to annotate data points on plots, evening pinning images to them. Therefore, with a bit of practice and work, you very well could likely make virtually the ENTIRE map+data figure in my original post in JMP alone. In fact, I may try to do just this in the coming weeks.

Thanks again to John for providing the solution!

Re: pie graphs+heat maps

John_Powell_JMP — Thu, 18 Dec 2025 13:53:13 GMT

Your welcome Anderson and DS,

I published a better custom graphics script example annotating three variables per point on a map.

It's on JMP Public. Just click on the following following link:

https://public.jmp.com/packages/5d605bce3560ce0d2cafd48b

I used simple bars(thick lines) to represent three contrived cell values per point. Pie shapes would take a bit more work, but I wanted to offer this up as a proof of concept. The JSL script can be seen and downloaded from the post details on JMP Public.

~John

Re: pie graphs+heat maps

abmayfield — Mon, 26 Aug 2019 00:05:58 GMT

John,
This is great! Do you think it could be done directly in Graph Builder or would it require scripting and advanced knowledge to do so? I know I can just modify the script but I’m just thinking in terms of streamlining it were I to go with this option over the pie graphs for tons and tons of data. Did it require a custom shape or did you manually pin all those icons in the map?

Re: pie graphs+heat maps

John_Powell_JMP — Mon, 26 Aug 2019 22:24:38 GMT

Anderson,

Graph Builder doesn't provide a way to place bar charts or pie charts at specific locations on a map. You can get around it by:

Creating a table from your Graph Builder graph where you use sample number in the map role (built using bars or the custom map shapes. This creates a table with sample number column and a column of images for each sample.
Copy the image column from the generated table back to the unstacked data table( make sure that the image column matches the order of the sample number. **
a. Label the image column OR b. Set 'Use as Marker' for the image column.
Using the unstacked data table, create a Contour Map in Graph Builder using salinity or temp column as the color Role.
Add a points element. Optionally using another color role.
If you follow step 3.a, the images will appear in hover labels. You can pin some hover labels and Replace Text to remove any unwanted hover label text.
if you follow step 3 b, all markers will be shown with the image from the image column. This can cause a cluttered display which you can resolve by zooming in or by deleting images that are overlapping.

** I found they were not in the same order, and had to sort before copying the image column. In hindsight, I realized I could have used a join or virtual join to get the images on the correct rows. I wish I would have read this first: https://community.jmp.com/t5/JSL-Cookbook/Geographic-Maps-with-Graphs-as-Markers/ta-p/53782.

I published both 3.a and 3.b here:

https://public.jmp.com/packages/Heat-contour-with-image-annotations/js-p/5d64597acf28b80f980812ba

About the method I used to draw the bars. I didn't use custom maps, I used the custom graphics script to calculate the length of the bars and to position them above each point.

When it comes to streamlining, JSL is often the best choice.

~John

Re: pie graphs+heat maps

John_Powell_JMP — Mon, 12 Oct 2020 21:16:49 GMT

This discussion inspired me to create a paper and presentation for JMP Discovery Americas 2020.

As I prepared the paper, I had time to experiment and improve on the techniques described in this post.

Included with the paper, are some resources (custom maps and examples) and detailed instructions on how to use them.

I hope you will find this post and my paper useful.

Thanks,

~John

Re: pie graphs+heat maps

abmayfield — Mon, 12 Oct 2020 23:03:24 GMT

John,

This is great, and I fully intend to watch the talk your week (it is on my schedule.). I think this capacity, along with the "graphlets," will open up all kinds of doors for overlaying data onto Graphbuilder graphs and plotting data onto custom figures (like the human body example we talked about earlier that is found somewhere on the JMP website in the form of a tutorial, I believe). I'll be curious to see if anyone has any suggestions in terms of aesthetics. I personally like the pie graphs, but maybe there is a better way we are not even considering? I like your idea of the video game style "health bars," too.

Come to think of it, maybe this could benefit epidemiologists. For instance, if you had infection rates overlaid on a lat-lon grid, then pinned wedges/pie graphs with additional information about patients or groups of patients on the contour plot, you could potentially add a layer of complexity that may not be possible using the standard GraphBuilder features (I guess for most types of data, the graphlets would work for this, too, though).

Re: pie graphs+heat maps

John_Powell_JMP — Tue, 13 Oct 2020 12:58:40 GMT

Anderson,

That human body example is used here : and here:

I saw your Discovery Summit Americas 2020 Presentation recording : but I'm looking to forward to seeing it live!

~John