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,
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,
