I'm attempting to create a graph that displays each value in a column along with how frequently it occurs, similar to a bar graph where the number of occurrences is on the y-axis and the value is on the x-axis. How will I go about doing this?

I'm utilizing Excel 2013.
Oct 21, 2022 in Others 4,503 views

## 1 answer to this question.

There is probably a better way to do this, but this is a working example. Let's assume this is your data:

```+---+
| 4 |
| 4 |
| 5 |
| 6 |
| 7 |
| 7 |
| 7 |
| 8 |
| 9 |
+---+```

This column should be copied and pasted into column B. Click Remove Duplicates after selecting it. Add the following formula to C1: =COUNTIF (A:A;B1) (Use a; in Excel 2010 and later, use a, otherwise. Click and drag the black square from C1's bottom right corner all the way down to column B's bottom.

Now, your spreadsheet ought to resemble the following (with the formula result instead of the formula itself):

```+---+---+------------------+
| A | B |        C         |
+---+---+------------------+ // Actual values of column C
| 4 | 4 | =COUNTIF(A:A;B1) | // 2
| 4 | 5 | =COUNTIF(A:A;B2) | // 1
| 5 | 6 | =COUNTIF(A:A;B3) | // 1
| 6 | 7 | =COUNTIF(A:A;B4) | // 3
| 7 | 8 | =COUNTIF(A:A;B5) | // 1
| 7 | 9 | =COUNTIF(A:A;B6) | // 1
| 7 |   |                  |
| 8 |   |                  |
| 9 |   |                  |
+---+---+------------------+
```

Finally, create a graph as you normally would. Make your Legend Entries (Series) your column C, and your Horizontal (Category) Axis Labels column B.

This will result in a graph looking like this:

• 63,160 points

## How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

## How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE