View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge[_2_] Nick Hodge[_2_] is offline
external usenet poster
 
Posts: 185
Default Pivottable, new funtion?

Christian

See answer in .misc

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Christian Stassen" wrote in
message ...
Hi there (sorry for dobbelt posting, was a mistake)

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!