Data from last of month, diagram first in month

[KML]

Dear all!

I’m using calc for various economical reporting. Data are normally per last of each month, but when I create diagrams, the first of each month is displayed in the diagram. I’m not quite sure if it’s related to my setup or a general bug/feature, so I’ve taken the liberty to attach both an example file with some random data and a screen shot.

I would expect and prefer the dates to be the last of each month also in the diagram.

In other cases where dates are more irregular, the labels on the diagram are like what I would expect.

I’m running version 24.2.7.2 on Linux Mint 22.1 Cinnamon.

Thanks for any input!

Kind regards
Karl Martin Lund

Date Issue.ods (23.6 KB)

[mariosv]

[karolus]

I would change the formatting of the x-axis to show only month.Year and IMHO would use Charttype »Column-chart«

ask125934.ods (25.1 KB)

or better with some tweaks on the scaling of x-axis
ask125934_2.ods (25.5 KB)

[KML]

Thanks for your reply! Using only MM.DDD as a date format is of course a workaround that haven’t occured to me!

BTW, in your second file (with tweaking of x-axis), I only see five columns, the first one is omitted.

[karolus]

@KML

in your second file (with tweaking of x-axis)

Ups ( a bit to much tweaking ) … please set the Minimum in Scaling back to 2025-01-01

[koyotak]

confige date as text
ask125934_3_035625.ods (21.5 KB)