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.