Ask Your Question

[Graph XY] Insert values X in DD/MMM

asked 2018-08-13 16:18:12 +0100

updated 2018-08-13 16:42:38 +0100

Hello, I have a database with LibreOffice Base with HSQLDB. The table has this fields: Table1( ID INT PRIMARY_KEY, date DATE, name VARCHAR(64), sugar INT);

I imported this table on LibreOffice Calc in order to create a graph XY, axis X for date and axis Y for sugar. But i want date in axis X without year value in order to compare years in the same period, infact years are the lines of the graph.

Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-13 18:52:32 +0100

Ratslinger gravatar image


Instead of using the table, base the data on a query where you create the date format you are looking for:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-13 16:18:12 +0100

Seen: 34 times

Last updated: Aug 13 '18