Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > uk.comp.sys.mac > #180281 > unrolled thread

Numbers: charting help

Back to article view | Back to uk.comp.sys.mac

Contents

  Numbers: charting help Ian McCall <ian@eruvia.org> - 2025-02-17 13:55 +0000
    Re: Numbers: charting help Bruce <07.013@scorecrow.com> - 2025-02-17 16:20 +0000

#180281 — Numbers: charting help

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.

[toc] | [next] | [standalone]

#180284

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

[toc] | [prev] | [standalone]

Back to top | Article view | uk.comp.sys.mac

csiph-web