Thanks for your help. Your insight helped me figure out what I needed to do.
C.L.Savage

"JulieD" wrote:

Hi

i'm not experiencing the problem ...

when you enter the second you have two rows created so the layout changes
to:

Average of xyz
Sum of bcd

now, i just right mouse click where it says "sum of bcd" and choose field
settings - average ... does this work for you?

if not what version are you running?

hope this helps
Cheers
JulieD

"csavage" wrote in message
...
How do I change how PivotChart data is summarized, from Sum to Average for
multilpe fields. It will do 'Average' for the first field, but when you
add
additional fields, it will only enter them as 'Sum' and not allow them to
be
changed to 'Average'.
Please help, Thanks.