In Waterfall and Box plots the bars do not start at zero and the space underneath the bar is transparent. I am trying to create a horizontal bar chart to depict a range between 2 values (pretty much a box plot in landscape). I am doing this by creating a stacked bar with a calculated “hidden” value. However, I can only colour the hidden bar white to match the background, which colours over the grid lines on the chart, what i need to do is colour it transparent so i can see the underlying gridlines. is this possible
The alternative would be a horizontal box plot