topic Re: Create pie chart images for each line of a data table in Discussions

Create pie chart images for each line of a data table

yvesprairie — Wed, 24 Jan 2024 07:08:40 GMT

Hi all,

I have a data table with say 6 columns, one identifies the sample site, 2 are X and Y coordinates of that site and the last 3 are the relative abundance of say 3 different species at that location. I simply want a map where each site is shown as a pie chart describing the relative abundance of the 3 species. It seems like an easy problem but I can't quite figure out how to do it. I presume I need first to create an image column with the pie chart images in it and then use that column as markers?

Thanks in advance, Yves

Re: Create pie chart images for each line of a data table

Florian_Vogt — Wed, 24 Jan 2024 09:33:50 GMT

Hi @yvesprairie ,

not too complicated I'd say.

What you need is:

1. Create the Pie Chart (without any filtering)

2. Create the Geographic Map Chart

3. Right Click a data point in the Geographic Map Chart and add a Hover Label

The Result is a Map with Labels showing the relative abundance of your variable (species) per location (Sweet benefit is that these Hover Labels are actual Graphs themselves, so you can drill down into a specific location by clicking on it):

How to do this:

1. Create Pie Chart in Graph Builder. You might need to stack you data first:

2. Once you created the Pie Chart, go to the Red Triangle > Save Script > To Clipboard

3. Create the Map Graph, right-click a data point and add the Hover Label via 'Hover Label' > 'Paste Graphlet'

Note: 'Paste Graphlet' only appears if you have copied a script to the clipboard before.

Hope that helps.

Best

Florian

Re: Create pie chart images for each line of a data table

yvesprairie — Wed, 24 Jan 2024 10:24:30 GMT

Fantastic, thank you very much Florian. How difficult would it be to now have the "pies" as markers instead of having them popup when one hovers over a point? This would be nice to produce a static map with all the information.

Thanks again, Yves

Re: Create pie chart images for each line of a data table

Florian_Vogt — Wed, 24 Jan 2024 10:53:03 GMT

Even that is possible, @yvesprairie .

Steps you can achieve this are:

1. Create a Column of Graphs

2. Create the Graph

3. Select the Graph Column as the Symbols

Here's a way:

1. You can make a Graph into a Data Table. Here, I created the Pie Chart and used the Wrap field to have one per City:

2. The Table is just containing the label and the graph in two columns. So you need to join it with your inital table (Table > Join)

3. Create the Graph and select the Graph Column as Symbols

Result:

In my example here the graphs are a bit small as Icons, so you might need to adjust the graphs size a bit.

Best

Florian

Re: Create pie chart images for each line of a data table

yvesprairie — Wed, 24 Jan 2024 11:20:09 GMT

Thank you again Florian. No wonder I love JMP! Yves