The pivot table looks promising, but I am having trouble getting it to
work. Let me provide a bit more information about my data and perhaps
you can help.
I have a whole series of dives for a single whale. I have separated the
data into dives and named the ranges, meaning A2:B190 is called dive_1
and A191:B286 is called dive_2 and so on. I would want to do what you
have done with the pivot table for each of these named dives. The
problem is when I place the name into the pivot table range, there are
not any column headers, so the data does not lay out as it does in your
example.
I have charted all of the dives, but I need to do the analysis
concretely as well.
Thanks again!
--
akbreezo
------------------------------------------------------------------------
akbreezo's Profile:
http://www.excelforum.com/member.php...o&userid=24312
View this thread:
http://www.excelforum.com/showthread...hreadid=379185