[Graph XY] Insert values X in DD/MMM

[LucaGasperini]

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.

[Ratslinger]

Hello,

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