Ask Your Question

I have a data full of labels. I want to plot on the X-axis, the labels. And the number of times each label occurred on the Y-axis. How to do this in Libre Office calc?

asked 2020-10-16 07:03:51 +0100

eval gravatar image

Sample Data a a a b b b b b z z z z

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-10-16 07:42:52 +0100

JohnSUN gravatar image

It's simple, fast and easy to do with the PivotTable:

Count Labels.gif

edit flag offensive delete link more


To create a pivot table, I used the option from the insert column: insert->pivot table...

eval gravatar imageeval ( 2020-10-20 15:02:05 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-16 07:03:51 +0100

Seen: 184 times

Last updated: Oct 16