Graphing the median in a Pivot Table (Excel 2007)

[Bfappraisal]

Hi all:

I'm trying to see if there is an easy to find and graph the median in a pivot table. I have been able to do it with the average, but there is no preset option in Excel 2007 for median.

Thanks

-Bruce

[dilipandey]

Hi Bruce,

Welcome to the forum.
As you got it correct, Median is not an option in Pivot but you can use the Median Function with dynamic range (defined name) for pivot table. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>