Numbers

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

  1. bongobus

    bongobus iPF Noob

    Joined:
    Jul 9, 2011
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Ratings:
    +0 / 0
    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

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,201
    Thanks Received:
    2,441
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,970 / 1
    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.
     
Similar Threads
  1. alkan
    Replies:
    4
    Views:
    3,527
  2. markskidmore
    Replies:
    4
    Views:
    1,197
  3. rmpresti
    Replies:
    3
    Views:
    577
  4. Richard Webb
    Replies:
    2
    Views:
    977
  5. Pauley
    Replies:
    9
    Views:
    903
Loading...

Share This Page

Search tags for this page

apple numbers chart update source

,

apple numbers forum