Ask Your Question
1

How to use third column as identifier? [closed]

asked 2014-05-02 16:23:25 +0100

bakslash gravatar image

updated 2015-09-07 00:40:28 +0100

Alex Kemp gravatar image

I want to draw a diagram from a three column sheet

Input

| Date          | Value         | Identifier |
| ------------- | ------------- | ---------- |
| 01-04-2014    | 1             | John       |
| 01-04-2014    | 2             | Maja       |
| 01-04-2014    | 27            | Jim        |
| 02-04-2014    | 32            | John       |
| 02-04-2014    | 12            | Maja       |
| 02-04-2014    | 5             | Jim        |
| ...           |               |            |

Expected output:

An independently line per identifier. Value on Y, Date on X.

How do I set this up in LibreOffice - Calc? I'm kind of overwhelmed of it
Oh and I don't want to use the identifier as column header
I'm using LibreOffice 4.1

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-02-21 20:05:28.790823

1 Answer

Sort by » oldest newest most voted
3

answered 2014-05-02 23:46:41 +0100

Regina gravatar image

Why do you not want the identifiers as column header? It is very easy to generate a derived table using Data > Pivot Table. Mark the source data and generate a Pivot Table with Date in 'Row fields', Identifier in 'Column fields', and Value in 'Data fields'. For your chart you need no totals, but you might be interested in the totals for other reasons. The Pivot Table converts the linear table into a cross table. Then mark the data from the Pivot Table and generate your chart. Example: Ask 2014-05-02 33421 .ods

edit flag offensive delete link more

Comments

works fine, thanks!

bakslash gravatar imagebakslash ( 2014-05-03 04:42:51 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-05-02 16:23:25 +0100

Seen: 120 times

Last updated: May 02 '14