I can get the data OK, but the chart then treats all the data as the same
series - when shown as a line chart I would like 3 lines (one for Max, one
for Min and one for average) but I get one line trying to show all results!!

Thanks.

"Jon Peltier" wrote:

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.