1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Numbers

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

  1. bongobus
    Offline

    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
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,929
    Thanks Received:
    1,799
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,897 / 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,380
  2. markskidmore
    Replies:
    4
    Views:
    1,076
  3. rmpresti
    Replies:
    3
    Views:
    457
  4. Richard Webb
    Replies:
    2
    Views:
    806
  5. Pauley
    Replies:
    9
    Views:
    667
Loading...

Share This Page

Search tags for this page

apple numbers chart update source

,

apple numbers forum