Fixing an overlay within a box plot

I needed a box plot for my calc sheet, and I ended up messing with a bar graph.

My only question is would there be a way to fix the overlap happening around the third quartile mark? (Shown below)


The way I styled the bar graph is that the IQR boxes use a border and no fill, while the “whiskers” use an axial gradient. (Shown Above)

This overlapping is coming from the right whisker, and with that, there were only three ways I could think of maybe fixing this. 1st, making the second color of the gradient (the white) transparent. 2nd, adding a border to the whisker but only for the left side. Or 3rd, bringing the IQR box to the front so that it’s shown on top.

I’m asking for help because I can’t find out how to do any of those, so help or additional suggestions are greatly appreciated!

Can you post an ODS with an example and its data? That will make it possible for the community to start where you are and put their minds to the task. Use the up arrow icon in the icon list to upload.

boxplot.ods (23.3 KB)

Hopefully this is everything needed. Thanks!

Add spacing values.
boxplot.ods (17.3 KB)

1 Like

I’m having even better luck adding just 0 for the lines breaks…might depend on graphics.

Also, I created two graphical T’s in Draw for whiskers and added them via Format Data Series, Image Tab, Tiled and Scaled, Import to the leftmost and rightmost bar regions, respectively to create an overall proper IQR chart. Don’t forget the Scale checkbox.

LeftWhisker

RightWhisker

BoxPlotWhiskered.ods (63.0 KB)

2 Likes