xlCategoryScale does not work for Date and Time axis

[Angie86]

Hello Everyone!

I am writing a code to organise some charts. In the x-axis I have date and time in the format "DD.MM.YYYY hh:mm:ss", and because all the measurements change with time, I need the x-axis to the format on Column B (Figure on the left). Initially, the axis ticks are numbers (Figure in the middle), and to change them to the format I want, I have used so far the following line, that based on some other questions, may work:

With Plot_Pressure
.Axes(xlCategory, xlPrimary).CategoryType = xlCategoryScale
End With

However, after running that the axis tick does not change and if I include the line ".Axes(xlCategory).TickLabels.NumberFormat = "dd.mm.yyyy hh:mm:ss"" after, the result is even worst (Figure on the right).

Could someone please help me with it?
I would really appreciate it!
Thanks!!!

 

[RoryA]

What result are you expecting? Your number format is quite long, so that's why you get the result in the third image.

 

[Angie86]

I am expecting to see at least the time interval in which the data should be.
Although my number format is too long, as you can see in the image the axis does not match, considering that my data goes from "01.09.2020 00:00:09" until "30.09.2020 23:59:59"

 

[RoryA]

As it looks like your data is at regular 10 second intervals, you could simply use a category axis. Alternatively, use an XY scatter chart with lines, and then alter the number format of the X axis to use a date format. It is unfortunately often very difficult to work out the problem with a chart from a picture rather than an actual workbook.