[Solved] Month and day from Datetime as X-axis labels

[sevensixtwo]

I am plotting a number as the y-axis and a datetime as the x-axis. When the x-axis tickmarks get made, it is converting the datetime to a number, e.g.: "45330." How do I get tickmarks that look like "Feb 10" or similar on the x-axis? A tickmark like an .ods date "02/10/24" would also be ok, but less preferable.

TEST.ods

(17.45 KiB) Downloaded 50 times

[Hagar Delest]

Hi and welcome to the forum!

Either you format the source value and make the X axis keep the source format in the Numbers tab of the X axis properties. Or you tune the X axis format, again in the Numbers tab of its properties.

See:

TEST Hagar.ods

(24.01 KiB) Downloaded 48 times

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the 🖉 button if your issue has been fixed.

[sevensixtwo]

Great, thanks. I did not realize that I could click on the x-axis to get its properties!

[sevensixtwo]

I have a few more questions, please. How do I add x- and y-axis labels to say "weight" and "date." Also, I added a best fit line, and I want to have the slope of the line displayed in the chart, computed in units of [number]/[days]? Thanks!

[MrProgrammer]

Hi, and welcome to the forum. Thank you for the attachment.

How do I add x- and y-axis labels to say "weight" and "date."

Insert → Titles → Axes → X axis → Date → Y axis → Weight → OK

I want to have the slope of the line displayed in the chart

Click the trend line → Format → Format selection → Type → Show equation → OK
Click the equation → Format → Format selection → Numbers → Decimal places → Your choice → OK

I did not realize that I could click on the x-axis to get its properties!

Calc Guide Chapter 3: Creating Charts and Graphs

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know