View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christian Stassen Christian Stassen is offline
external usenet poster
 
Posts: 1
Default Functions in a pivot table

Hi

I'm doing a pivottable. In the "values" field, I can choose between
calculating the max, the mean, the standard deviation etc. But is there some
way in which I can define my own funtions? For example, I'd like to calculate
the median?

Another thing: I'd like to make a graph that only uses the numbers in the
pivottable, i.e., it changes when I change the parameters in the table. Is
that possible?

Thanks!