Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Scott,
This is an interesting scenario that you have. I have tried to re-create a close enough replica for your chart. Please Refer the below image :
Though it is not possible at this point to both group & stack the bars at the same time. We can try to merge the Month & Remidition Categories in to 1 field using concat or '&', then sort then in such a way that the same month bars are in order. using an epression like : (Month(Month)*4)+WildMatch(Category,'Rem','UnRem','Not Req').
Try this out & revert if you face any issues.
Regards,
Rohan.
Thanks Rohan, that's a good suggestion! Do you know if its then possible to somehow improve the formatting to put a space between each of the sets of 3 bars?
Hi Scott,
I do have a faint hunch on how that can be achieved, I am trying to get it right at my end once. By that time, can you check if you can handle the seperations using reference lines on x-axis ? I highly doubt it'll work, but worth a shot. I'll get back to you if my way works out, but it'll be a tad bit tidious to explain over, in words.
Regards,
Rohan.