How to Make Box & Whisker Plots in Excel 2007. Microsoft Excel, a spreadsheet and data analysis program, is available as a stand-alone program or as a component of the Microsoft Office ...

Follow the steps below to create a Box and Whisker Chart in Microsoft Excel: Create a table or use an existing table. Highlight the data in your table.

Open a new Excel spreadsheet. Click cell A1 and type "Data Set" into the cell. Click cell A2 and type in the first value for the data set that you want to make into a percentile graph.