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.

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.

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.

When you have more than one field in the data area, Excel lists them one
below the other. The Data field button is placed in the Rows area. Drag the
Data field button to the Columns area, so Average, Min, and Max are listed
side by side, and the chart should provide what you need.

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


"Andy" wrote in message
...
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.

Many Thanks - dragging the "Data" button did the trick I was after!

Thanks,

Andy.

PS. Like the 'Speedometer' chart on your website!

"Jon Peltier" wrote:

When you have more than one field in the data area, Excel lists them one
below the other. The Data field button is placed in the Rows area. Drag the
Data field button to the Columns area, so Average, Min, and Max are listed
side by side, and the chart should provide what you need.

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


"Andy" wrote in message
...
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.