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.
