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!

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!