Calculates individual and cumulative percentages for a range of data and a corresponding range of data bins.
If this function is not available, you must install the Analysis ToolPak add-in.
Syntax
HISTOGRAM(inprng, outrng, binrng, pareto, chartc, chart, labels)
HISTOGRAM?(inprng, outrng, binrng, pareto, chartc, chart, labels)
Inprng is the input range.
Outrng is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.
Binrng is an optional set of numbers that define the bin ranges. The values must be in ascending order. The values are interpreted as more than value A up to value B, more than value B up to value C, and so on. One additional bin is created for values for less than the minimum value specified in binrng.
Pareto is a logical value.
If pareto is TRUE, data in the output table is presented in both ascending-bin order and descending-frequency order.
If pareto is FALSE or omitted, data in the output table is presented in ascending-bin order only.
Chartc is a logical value. If chartc is TRUE, HISTOGRAM generates a cumulative percentages column in the output table. If both chartc and chart are TRUE, HISTOGRAM also includes a cumulative percentage line in the histogram chart. If omitted, chartc is FALSE.
Chart is a logical value. If chart is TRUE, HISTOGRAM generates a histogram chart in addition to the output table. If omitted, chart is FALSE.
Labels is a logical value.
If labels is TRUE, then the first row or column of inprng contains labels.
If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.
Return to index