I am working in Excel 2003 and have set up a pivot chart with two series of
data in the data area. When I only use one of them the default it sum I can
change it to average or whatever I want. When the second series is added the
first is still average but the second defaults to sum and I can't change it.
Is there a way to change the pivot table default from sum to average so if I
add a second series it will use average instead of sum?
I can just drag the series in and out but just wanted to know. Thank you for
your help.

Tim Peter