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.
Excel graph axis label orientation series#
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).
![excel graph axis label orientation excel graph axis label orientation](https://i.stack.imgur.com/QYMU4.png)
In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK.In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit.There should be no blank rows or columns. 264How can I make an Excel chart refer to column or row headings?Īrrange your data so that headings are directly above and to the left of the data to be charted.