Kibana version:
8.12.1

Elasticsearch version:
8.12.1

Server OS version:
Ubuntu 24.04

Browser version:
Chrome 129.0.6668.90

Browser OS version:
Windows 10

Original install method (e.g. download page, yum, from source, etc.):
deb

Describe the bug:
When a Lens visualisation has a dimension which has been configured to be of Value format "Duration", and the chart goes in to negative space, the axis doesn't render values less than 0. The chart itself renders fine, just the axis values are incorrect.

Refer screenshot below.

Steps to reproduce:

1. Create a new lens vis
2. Select a numeric type as the data series
3. Ensure the series has significant negative values (e.g., set the Formula to 0-<field.name>)
4. Observe the axis tick values on the bottom half of the axis are zero

Expected behavior:
Correct values display. Arguably in friendly mode the string "ago" should be appended, but at the least the numbers displayed should reflect the actual values at that horizontal.

Screenshots (if relevant):

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

Any additional context: