Discussion in 'iWork Forum' started by bongobus, Jul 9, 2011.

  1. bongobus

    Expand Collapse
    iPF Noob

    Jul 9, 2011
    Thanks Received:
    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 ?
  2. twerppoet

    Expand Collapse
    iPad Legend II

    Jan 8, 2011
    Thanks Received:
    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.

Share This Page

Search tags for this page

apple numbers chart update source


apple numbers forum