Numbers Chart Help!!

Discussion in 'Mac Apps and Mac App Store' started by bstadnik, Nov 18, 2009.

  1. bstadnik macrumors newbie

    Joined:
    Oct 28, 2008
    #1
    I can't seem to figure out how to create a chart based on the following info:

    I have 3 columns: Date, Time & Value

    Looks like this:

    Date Time Value
    10/1/09 12:00am 35.5
    10/1/09 01:00am 33.4
    10/1/09 02:00am 17.5
    .
    .
    10/2/09 12:00am 27.4
    10/2/09 01:00am 44.5
    10/2/09 02:00am 3.5
    .
    .
    10/31/09 12:00am 56.5
    10/31/09 01:00am 15.7
    10/31/09 02:00am 10.4

    I want to create a chart that shows the highest given value for each day (regardless of which hour it occurred) and another chart with the highest given value by hour.

    In the above sample the chart would show:

    10/1/09 56.7
    10/2/09 44.5
    10/31/09 56.6

    12:00am 56.5
    01:00am 44.5
    02:00am 17.5
    I am able to do this in excel very quickly by using a Pivot Chart, but can't seem to figure this out in Numbers.

    I hope this makes sense.

    Thanks,
     
  2. Ashka macrumors 6502a

    Ashka

    Joined:
    Aug 9, 2008
    Location:
    New Zealand

Share This Page