You can add the temperature field to the Data Area of the same pivot table
multiple times, one for Average, one for Maximum, and one for Minimum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andy" wrote in message
...
I am using Pivot Tables in Excel 2002 to manipulate weather data. From the
hourly data I am using pivot tables and charts to show daily averages. I
would also like to use the same table/chart to show maximum and minimum
values - at present I have had to use three separate pivot tables - but am
sure there must be an easier way!!

Thanks.