Data replicates over Bar graphs

[laura hertzParticipant]

I am trying to make a figure like Fig. 2C in this article. However, using Pivot and Bar, I can only get the data points between the two bars instead of on top of their respective bar. Photos posted below

• This topic was modified 3 years, 8 months ago by laura hertz. Reason: Clarification of what I was actually asking about
• This topic was modified 3 years, 8 months ago by laura hertz. Reason: Couldn't add photos to the origional post, but was able to post them in the follow up

[laura hertzParticipant]

Fig 2C

My graph:

[dgteamModerator]

The Box command only groups in one category at a time, so you will need to have two Box commands, where each one has a mask and is offset to overlay the bars.

To do this, select the box command you already created with the points option.  Expand the command and add a negative offset and a mask to limit to the appropriate data.

Then you can make copy of the Box command (select and use command-C and command-V).  Edit the copy to have a the same offset but positive.  And update the mask.

Does that help?

 

[dgteamModerator]

Laura,

We also just uploaded a similar example (File > On-line examples).

The file also includes this as an alternate way to represent.

[laura hertzParticipant]

Yes!!! Thank you, this is exactly what I needed, thank you so much for explaining it. So simple. I never would have figured out the masking mechanism. Very excited to share this feature with my lab

[dgteamModerator]

Excellent!  Glad this was helpful.

To learn more about masks, check out this webinar from last September: Mastering Masks

[Author]

Posts