Ask Your Question

create chart from values single column [closed]

asked 2014-11-03 02:36:37 +0200

manchine gravatar image

updated 2020-07-12 19:48:51 +0200

Alex Kemp gravatar image

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.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 18:41:57.510182

2 Answers

Sort by » oldest newest most voted

answered 2014-11-03 06:59:22 +0200

karolus gravatar image


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

edit flag offensive delete link more


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

ROSt52 gravatar imageROSt52 ( 2014-11-03 07:12:18 +0200 )edit

answered 2014-11-03 05:14:47 +0200

ROSt52 gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-11-03 02:36:37 +0200

Seen: 2,768 times

Last updated: Nov 03 '14