Boxplot

ARC,

There is no built-in Box Plot capability in Numbers. How to do it manually depends on how you define a Box Plot. There are endless variations on the Box Plot. It also depends on whether you are doing this once for an important presentation and can spend great amounts of time on it, or if you want a convenient method for repeated use, in which case you're going to have to be very creative in the generation of templates.

Jerry

You may be able to do something with a stacked bar chart or with custom error bars on a line chart.

With stacked bars, you can use a clear bar for the bottom (so the colored bars start at your minimum values), one color to get from minimum to average (or median, or whatever your data point is), and another color from the data point to maximum. With simple math, these three series can be created in a table and plotted.

With a line chart (or a bar chart), custom error bars will let you choose the data to use for the positive parts and negative parts of the bars so you can indicate your minimums and maximums, you just need to have two columns of data for the error bars. Again, simple math to make two additional data series.

Message was edited by: Badunit

A line chart is your best starting point. This will allow you to use the error bars of more than one series to represent your quartiles. With a bar chart the series won't overlay each other - they will be offset.

Jerry

These are the two ideas I had. The stacked bars only works with positive numbers.