Trying to make an advanced graph builder but not sure if my tables are correct

patriciafm811 — Mon, 03 Jun 2024 12:02:34 GMT

Hello,

This is a somewhat complicated request, so I hope I am clear with what I need and have.

I currently have this graphic: but it is confusing and I need to add more to clarify it.

I need it to include the total number of all the centers (like it currently is on the right y-axis). But I also need to include the number of centers (along with the percent) labelled in the bar for the left y-axis. I also don't know where the labels for the green go, but I need them back (I lose them when I switch the left y-axis scale to start at 80%).

I have attached 2 tables. The GRF VM Trends is the one I used to make this table, but I don't know if it has everything. The 'Stacked and Binned' table has more data, but not the number of total centers.

My team is looking to potentially create something like the two following tables:

I want to know if the data in one or both of my tables is set up right and how I can go about making this, or at least have a start. I can do JSL and scripting as well. Using JMP 17.

topic Trying to make an advanced graph builder but not sure if my tables are correct in Discussions

Trying to make an advanced graph builder but not sure if my tables are correct