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

1 Answer

Sort by » oldest newest most voted
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: 276 times

Last updated: May 28 '15