I have.a spreadsheet on which I’m tracking mileage vs a lease I have. I
read the mileage from the car, note the date, and put it in the sheet. The sheet will calculate the ‘allowed’ mileage by that date, compares to my actual mileage and then tells me a few things like how many days to converge, what percentage of the lease remaining is required to converge etc.. Can set most of this aside for this question.

I would like a simple sheet showing a line graph in two colours, on the y
axis:
- ‘allowed’ mileage
- actual mileage

I would like the x axis to be fixed and show dates:
- y axis origin point should be the first date of the lease
- y axis should end at the maximum date of the lease.

So crudely, in ASCII...

5,000

4,500

4,000

3,500 ------------------------------------------------------------------------------ -----------------------------------
2024-11-23 2025-02-23 2025-05-23..................<end of lease>

The table looks like:

Date, allowed mileage, actual mileage, <various calculated columns> <-- I
only care about the first three columns for this graph.

Make sense? I can’t see how to set this up - selecting the three columns
and inserting a line chart always give the dates as a y axis and I can’t
see how to set it otherwise, let alone to fixed intervals.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 17/02/2025 13:55, Ian McCall wrote:

I have.a spreadsheet on which I’m tracking mileage vs a lease I have. I read the mileage from the car, note the date, and put it in the sheet. The sheet will calculate the ‘allowed’ mileage by that date, compares to my actual mileage and then tells me a few things like how many days to converge, what percentage of the lease remaining is required to converge etc.. Can set most of this aside for this question.

I would like a simple sheet showing a line graph in two colours, on the y axis:
- ‘allowed’ mileage
- actual mileage

I would like the x axis to be fixed and show dates:
- y axis origin point should be the first date of the lease
- y axis should end at the maximum date of the lease.

So crudely, in ASCII...

5,000

4,500

4,000

3,500 ------------------------------------------------------------------------------
-----------------------------------
2024-11-23 2025-02-23 2025-05-23..................<end of lease>

The table looks like:

Date, allowed mileage, actual mileage, <various calculated columns> <-- I only care about the first three columns for this graph.

Make sense? I can’t see how to set this up - selecting the three columns and inserting a line chart always give the dates as a y axis and I can’t see how to set it otherwise, let alone to fixed intervals.

It's a pain isn't it: both Numbers and Excel make this really fiddly
whereas good old Lotus 123 made this trivial. Such is progress.

Create three columns: Date, Allowed, Actual. In the rows beneath put
your data. Make sure the date column is formatted as a date/time value
(but hide the time).

Select the whole table (all cols, all rows) and choose insert graph.
Choose the XY scatter plot style (bottom left).

You should get dates across the bottom - evenly spaced - and dots on the
graph at the appropriate intersection points.

Click on one of the dots and the "Series" tab should appear at the
right. Choose "connection lines" straight or curved as you wish.

Regards,
--
Bruce Horrocks
Hampshire, England

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)