Creating a horisontal boxplot

Question

Hi,

I have tried to figure out how to transform the vertical boxplot below to a horisontal one using Excel 2016 but I can't find any solution.

Is there any way of doing this? 

Answer 1

Are you sure about that? I find it strange that they added a function to create a vertical boxplot without adding any way of creating a horisontal one (they are not that uncommon after all)?

//Johan

Answer 2

I am asking other experts to assist you. If there is a way, other experts will pitch in.

Answer 3

Everything I've seen suggests that boxplot provided by MS is only vertical.

https://support.office.com/en-us/article/create...

I have seen this utility you can buy to do horizontal box plots

PELTIER TECH BOX AND WHISKER CHART UTILITY

Quickly and easily create professional box and whisker plots.

Use raw data or compiled statistics.

Show or hide outlying data points.

Choose horizontal or vertical orientation.

Create box plots from within your own code.

Read More About the Peltier Tech Box and Whisker Chart Utility

Purchase the Peltier Tech Box and Whisker Chart Utility ($59 US)

http://peltiertech.com/Utility/CascadeUtility.html

Since they can do it, I imagine with some creativity you could do it also ...

... Oh, look at this, actually, they provide how-to instructions

https://peltiertech.com/excel-box-and-whisker-d...

Answer 4

If you need Horizontal box plot, then you need to follow below directions

https://peltiertech.com/excel-box-and-whisker-d...