For example, three of my whisker – numbers are 54, 38, and 63, but my down whisker extends to -16, -18, and 22 respectively. The down whisker goes to minus 18, when the lowest number in my ‘Whisker-‘ row is 2. Why are my whisker lines showing negative values when there are none in my dataset?

I hope you’re still checking back on this thread, as I have a question I’d like your help with. This is by far the clearest and most helpful guide to making these charts on the web, thanks for putting it together. If this has made any sense at all please could you let me know how i would go about making a box and whisker plot like this. Each Drug A dose on Y axis will have two box and whisker plots, one black and one grey.

I.e there will be a legend saying black box and whisker is with Drug B and grey box and whisker is without Drug B. I need to make a box and whisker plot but with 8 box and whiskers but they need to be different colours/shades within their drug group. I need to group these 8 groups into 4 groups comparing Drug A has doses 0, 110, 210, 330 and drug B has one dose 200. I need to make a box and whisker plot in Excel but I am comparing combinations of drugs. Hi there, I am wondering if you can help me. Box and Whisker Charts in Peltier Tech Charts for Excel If you’ve made a horizontal box plot, hide the secondary Y axis (right edge of the chart) by choosing no tick marks, no tick labels, and no line in the Format Axis dialog.

Finally, select the secondary horizontal axis (top) and click Delete Excel will now plot the XY series on the primary horizontal axis.Īll Versions: Now format the mean series: remove the line, and use an appropriate marker of a contrasting color. Double click on the secondary horizontal axis (top of chart), and on the scale tab of the Format Axis dialog, check “Value (Y) Axis Crosses at Maximum Value” (below right).Įxcel 2003, continued: Double click the secondary vertical axis (right of chart), and on the scale tab, check “Values in Reverse Order” and uncheck “Value (X) Axis Crosses at Maximum Value” (below left). Excel draws both secondary axes, but the vertical one is hidden behind the primary axis with the text labels (below left). If you’re making a horizontal box plot in Excel 2003, this last process is a little more involved.

Excel box and whisker 2016