Microsoft Excel, a spreadsheet and data analysis ... One feature that was lacking however was an easy way to make box-and-whisker plots, so-called because their outliers resemble cat whiskers.

So, you want to know how to create a scatter plot in Excel ... but we can put the horizontal axis title back on our chart and “cheat.” Unfortunately, the axis title text box doesn’t ...

Now we are going to position the horizontal axis ... check the checkbox for Categories in reverse order. Excel will reverse the plot order.