Numbers

[bongobus]

Hi Newbie here,

Can someone help on this

I have numbers on my ipad which is version 1.4

Im sure this worked along time ago when i first purchased last year but since the updates no longer does charts how i wanted.

I can only get a chart to be produced (Stacked BarGraph) if the source data is a number

I used to have it set up that the data was as a result of formulas using dates

Example 1 cell contained a start date
another had a future date
and lastly one had todays date

I had set up so the future date minus the todays date produced a result example 3d and another cell the full period example future date minus the start date 10d

So this chart would change over time itself based on to cells 3d & 10d in same chart stacked column

ever since the update it no longer worked - anything im doing wrong ?

 

[twerppoet]

I don't know how it worked before, but try this. Place your formula inside the function DUR2DAYS.

DUR2DAYS(C2-B2) where C2 is the end date and B2 is the start date.