Ask Your Question
0

Histogram over distinct values

asked 2015-05-27 21:41:34 +0200

Aaron Digulla gravatar image

updated 2015-08-26 19:59:54 +0200

Alex Kemp gravatar image

I have a calc sheet with a column like this:

 A
 B
 B
 B
 A
 C

and I'd like to create a diagram which displays

 A 2
 B 3
 C 1

i.e. the distinct texts and how often each text appears.

I'm using LibreOffice 4.3

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-09-26 11:16:29 +0200

Aaron Digulla gravatar image

Have your data in column A (A1:A6 in the example).

Create a Standard Filter (Menu Data -> More Filters -> Standard Filter...)

In the first row:

  • Field name: Column A
  • Condition: =
  • Value: Not Empty (can be found in the dropdown)

Reveal the "Options" below.

Select "No duplicates"

Select "Copy result to:" and enter B1 into the text field.

The result should look like this:

image description

Click "OK". You should now see "A B C" in column B1:B3

In cell C1, enter this formula: =COUNTIF(A$1:A$6;B1)

That gives you the count of A in column A.

Copy this cell once for every value in column B (three times in the example).

Lastly, you can create a histogram using the cells in B and C. Click Menu Insert -> Chart... and you're done:

image description

edit flag offensive delete link more
0

answered 2015-05-28 04:41:21 +0200

horst gravatar image

Try the FREQUENCY Function. The help shows an example that can be adlusted to your problem.

edit flag offensive delete link more

Comments

My help doesn't show this; in fact, it doesn't contain a "FREQUENCY" function. Part of the problem is that I'm using a German version.

Aaron Digulla gravatar imageAaron Digulla ( 2015-05-28 20:00:57 +0200 )edit

Could be Verteilung or Häufigkeit. I'm German but work only with english versions. Es ist HÄUFIGKEIT. Im deutschen forum gefunden.

horst gravatar imagehorst ( 2015-05-29 03:16:45 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-27 21:41:34 +0200

Seen: 423 times

Last updated: Sep 26 '19