Create chart from values single column

I have a Country column where country names are stored.
My aim is to generate a bar chart where the number of occurrences for each of those country names is graphed.
How can I turn a series of values in a given column into a chart?

Running LibreOffice on Mac OS X 10.10 Yosemite.



Mark the Column and choose →Data→PivotTable→Create...

  1. drag and drop countrynames to Rowfield
  2. drag and drop countrynames to Datafield change Function from sum to count
  3. hit ok

create the chart from output of Pivottable

1 Like

@karolus - this is definitely the best solution! I forgot about the pivot table.

The solution depends very much on your conditions.

If you have only a few country names you can create a table where in colm1 you write your country names and in colm2 you for each country the countif function using the specific country name in the argument and as the data range you use your entire column which contains all the country names you want to count.

If you have many country names you might better use subtotals. Once you have your subtotal you need to display only the subtotals. From there you can create your chart, showing the number of occurrences for each country name.