Stacked Sum bar chart with overlay and Line Sum graph without overlay

Evan_Morris — Sun, 11 Jun 2023 11:13:59 GMT

I have a stacked bar chart that I am having some issues with. I want to see the partial contributions of each participant, some positive, some negative, and I would like to see the grand sum as well.

To see the individual contributions I use the overlay to split them out. But if I do that then I can't see the grand Sum. See below:

So what I would like would be for the bottom graph to just be the sum line not split out by the overlay. The other solution I've come up with is a nested graphlet, but that really doesn't work for me. I've been looking at the JSL for a bit and it doesn't seem like you can select which property/Y the overlay applies to, but I'm not certain.

I know I could create a window with a V list box with two separate graphs. That's really my last resort option. The absolute best option would be to have the Total Sum Line Graph sitting on top of the Stacked Sum Bar Chart with Overlay.

Is there an easy way to do this? I know I've seen some custom code on here for adding total labels to the graph, but to be perfectly honest that's a bit beyond me.

Re: Stacked Sum bar chart with overlay and Line Sum graph without overlay

jthi — Sun, 16 May 2021 07:31:17 GMT

You should be able to remove the effect of Overlay selection from different plot types.

Example from Big Class with one value changed to negative:

topic Re: Stacked Sum bar chart with overlay and Line Sum graph without overlay in Discussions

Stacked Sum bar chart with overlay and Line Sum graph without overlay

Re: Stacked Sum bar chart with overlay and Line Sum graph without overlay