Used an Array to Add a Median to Pivot Table- Now need Median to also appear on graph

		Microsoft Office Forums > Microsoft Excel > Excel
Used an Array to Add a Median to Pivot Table- Now need Median to also appear on graph

FAQ

Thread Tools

Display Modes

04-25-2017, 08:45 AM

xor

Windows 10 Used an Array to Add a Median to Pivot Table- Now need Median to also appear on graph

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Adding information from a array into a table	jcorti	Word VBA	4	01-10-2014 10:58 PM
Copying pivot table and graph to a new worksheet	artner0112	Excel	0	02-02-2013 07:19 PM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Excel Not Finding the Median	BrazzellMarketing	Excel	4	02-17-2012 02:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:31 PM.