Search code examples
excelexcel-formulaexcel-charts

Bar chart or histogram of grouped values

enter image description here

For a table as above how can I count how many labels have value between [0-2] and [3-5] and with Excel show that as a bar chart or histogram?

Solution

  • PivotChart example (value in ROWS, label in COLUMNS and Sum of value for VALUES):

    SO34157579 first example

    Oh! I forgot to mention that the banding [0-2] or [3-5] can be achieved by Group in the PT - select Row labels and start at 0, end at 2, in steps of 2.

    For this instead:

    SO34157579 second example

    remove label from LEGEND(SERIES) (COLUMNS) and use Count of rather than Sum of value.