Hi Jordie, Box and Whisker and other new charts available in Excel 2016 are not available in Excel for the Mac. In fact, they won't even display in Excel 2016 on the Mac.

All you will see is a box telling you that they are not supported. They will most likely be supported in a future update, but for now they're off limits in Mac versions of Office.

The box (and whisker) plot is very poorly supported in Excel. You can follow a tutorial to make one of these and then automate that tutorial with VBA.

Microsoft is in the process of folding Office for Mac into Office for Windows groupings. The Mac MVPs have mostly been reassigned to other Office categories. I anticipate that when all the changes have been made, in the future, Office for Mac will be listed under Office instead of having its own category. That's just an educated guess on my part, though. I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.

• Open your Excel data. This instructional will assume that your first data column is in column 'A,' your first data value is in row '1,' and all your columns have 'n' data points.

• Create new rows for your maximum, upper quartile, median, lower quartile and minimum values. • Calculate these statistics by entering the following values under your 'A' column: =MAX(A1:An) =PERCENTILE(A1:An,0.75) =MEDIAN(A1:An) =PERCENTILE(A1:An,0.25) =MIN(A1:An) • Copy and paste the same formulas to calculate statistics for your other columns, changing the letter for the corresponding column. • Select all the fields with your new statistical calculations. You can press 'CTRL' to select from more than one column. Winzip free download for mac os x 10.6.8. • Click the 'Excel Chart Wizard' button.

• Select the 'Stock Open-High-Low-Close' diagram. • Click 'Next.'

In the Data Range tab, click on 'Series In: Rows.' • Click 'Finish.'

A box and whisker chart will display. • Was this answer helpful? Related Questions Q: A: Launch Excel 2007. Create two columns of data, one for each variable, in an Excel spread sheet. Canon 6030w driver for mac. These columns should be made up of a varia. Q: A: Rename a blank Excel worksheet 'Data' by clicking the bottom tab for the worksheet and typing the new name.

Rename another blank Excel wor. Q: A: Click on a chart inside of the Excel spreadsheet to select it.

Click on the 'Layout' tab in the Office ribbon that appears once the chart. Q: A:A normal probability plot for Excel 2007 shows the normal distribution, sometimes called a 'Bell Curve.' The normal distribu. Q: A: Open the Excel file that contains the data you want to represent as a box plot. Scroll to the bottom of the data set and type in five new.