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.