cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
MrS
MrS
Level I

Help with stacked bar graph/overlaying bar graphs

Does anyone have any advice for modifying graph builders default scripts? I'm trying to build a stacked bar graph of some data but my issue is that jmps "stacked" option sums all of my data together (stacking it all), when I would rather it not sum the data and essentially overlay the different layers into one bar. Here are some pictures to help.

So my starting point is this bar graph, with my different classes represented side-by-side.

side.PNG

As you can see here my highest value is roughly 1:00:00. I would like to condense each of the coverage categories into one bar, but the default options are not pretty. If I stack them (see below) it sums them all and my highest value becomes 4:00:00 which is not desirable. 
stacked.PNG

 The closest option is nested (below), but frankly this looks absolutely terrible and hurts my eyes. nested.PNG

 Is there a way to modify this nested format so all the bars have the same width, and the shortest ORF Length bar is placed as the top layer, so that all ORF Length bars are visible in a single bar. 

 

Bullet style (below) is also a similar option. But the problem here is; again not all bars are equal widths, and more importlantly it doesn't reorder how the ORF Length bars are ordered, so many of the shorter bars (ie 500) are hidden behind larger bars.bullet.PNG

 

 

Anyone have any thoughts or ideas how to fix/clean this up? Attached is the data table if anyone wants to play with it. I'm essentially trying to hybridize the nested and bullet formats. Also when trying to modify the scripts the types are just listed as "stacked", "bullet", etc. Does anyone know where these type modifiers point to so I could manually play with those parts of the scripts? 

 

edit: Here is what I'm trying to do (this is just a manual mockup from powerpoint using rectangles to construct my bars). I'm looking at how long it took a program to execute a command on various datasets (coverage level) with different settings enabled (ORF Length). So every coverage level at every ORF length is an independent run with its own result. Here I'm going for the visual aesthetic of the stacked bar graph, but overlaying NOT stacking the bars. So each color bar accurately depicts the time it took for that individual process. Demo.PNG

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
XanGregg
Staff

Re: Help with stacked bar graph/overlaying bar graphs

To get this kind of view, I would sort the table by group and value, compute the value deltas in a new column, and then stack those delta values. However, you still may have a challenge convincing other viewers that these are overlaid bars instead of regular stacked bars.

 

Here are a couple more options: a line chart and the "float" style of bar chart ,which essentially is just showing the tops of your overlaid bars. 

Screen Shot 2018-03-27 at 9.18.13 PM.pngScreen Shot 2018-03-27 at 9.18.33 PM.png

View solution in original post

5 REPLIES 5
dale_lehman
Level VII

Re: Help with stacked bar graph

I may be completely off base with this, but I don't really understand what you are trying to do.  Using time on the Y axis seems to me to call for not using a bar chart at all.  I've attached a different version (the second stored script) that could be what you are looking for.  If not, then just ignore this.

MrS
MrS
Level I

Re: Help with stacked bar graph

Thanks Dale for that script, and while it's not what I'm trying to do with this graph I may use it for other things. This may help, here's a quick hack of what I would like to do (just done in powerpoint manually with rectangles for the bars).Demo.PNG

 

 

I'm looking at the time it took a single program to complete a task with different settings (ORF length) on different datasets (coverage levels). So this format (the fake one above) is really the most useful to me. However, I'm struggling to get jmp to recreate that graph

Phil_Kay
Staff

Re: Help with stacked bar graph

I struggled to understand what you were trying to achieve at first. But I think I get it now. The bars are completely overlaying the ones behind.

 

I imagine there wold be some way to recreate this in JMP but I do not think it will be simple. As far as I am aware there is no standard option to do this.

 

In my opinion there is a problem with the graph that you have proposed in that people will not understand that the bars for other categories are overlayed on top of each other. They will assume that this is classic stacked bar chart. So they will think that 500 is the biggest ORF length category for 0.1 coverage when it is, as I understand it, the smallest category.

 

But perhaps the graph is for your eyes only. Understanding the audience is important in deciding upon the visualisation to use.

 

Personally I am not a fan of stacked bars in any case as they make comparisons difficult.

 

I think you can create a better visualisation of this data that will communicate the data more clearly to the intended audience. I think I would try Run Time on the X-axis, ORF length categories on the Y-axis and Coverage in the Group X or Wrap roles. 

 

Sorry I coudn't help with creating the graph that you want.

 

Phil

XanGregg
Staff

Re: Help with stacked bar graph/overlaying bar graphs

To get this kind of view, I would sort the table by group and value, compute the value deltas in a new column, and then stack those delta values. However, you still may have a challenge convincing other viewers that these are overlaid bars instead of regular stacked bars.

 

Here are a couple more options: a line chart and the "float" style of bar chart ,which essentially is just showing the tops of your overlaid bars. 

Screen Shot 2018-03-27 at 9.18.13 PM.pngScreen Shot 2018-03-27 at 9.18.33 PM.png

ezorlo
Level IV

Re: Help with stacked bar graph/overlaying bar graphs

Did u try using the color option? 

You can use color and overlay at the same time, maybe that can help

E.g. overall time is the overlay

and then the individual process goes into color. or vice versa- try em out i do thesame thing to show different abundances of taxonmic levels

also very important- select row order levels as the value order of the columns in the data table that has the order you want

good luck