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.
