Ask Your Question
0

create chart from values single column [closed]

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

manchine gravatar image

updated 2016-03-05 18:41:49 +0100

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 4.3.0.4 on Mac OS X 10.10 Yosemite.

Screenshot: https://www.dropbox.com/s/2vi07q494y8...

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
1

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

karolus gravatar image

Hallo

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

Comments

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

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

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

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

Stats

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

Seen: 1,972 times

Last updated: Nov 03 '14