Did you try using average instead of sum in the PivotTable field box?



SJT Wrote:
I am creating a pivot table with approximately five columns. One of
the
columns is called "margin". Another of the columns is "category".
What is
of importance to me is the avg. margin of each "category" not the
total
margin. Is there a means of calculating the average and including it
in the
pivot table and then creating a pivot chart? If not, how would you
recommend
I present the data so that I can chart the average monthly? "Month"
is
anothe of the columns. Thank you in advance for your cooperation.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=516900