Christian
If I understand, both things are possible (I am letting you know this for
2003 version)
1) You can define your own function in a PT and these then appear as new
fields to place where you want. In the pivot table toolbar (this should
appear when you select a PT) Look for formulas and calculated field. The
dialog takes a bit of getting used to, but should be ok if you have got as
far as a PT anyhow.
2) Just build a pivot chart from you pivot table (again via the PT toolbar)
and any changes you make to the PT will reflect in the chart
--
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" <Christian
wrote in
message ...
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!