Thread: [Solved] Used an Array to Add a Median to Pivot Table- Now need Median to also appear on graph
View Single Post
 
Old 04-25-2017, 08:45 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I have added column E in sheet Data and here calculated the median using a formula similar to your own.

Note that the median in Pivot_2 is exactly 32 while =AVERAGE(Data!C2:C100) is 32,8484848484849.

Please note that the data source of Pivot_2 is Data!A1:E100.
Reply With Quote