+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    usa
    MS-Off Ver
    Office Pro 2010
    Posts
    2

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

    Ok everyone, I have spent some time trying to work this out but I feel that I need to ask for assistance. I have a simple data table, that has a daily time value added for each day. Table includes three critical fields. Date and Time (how long it took for a process to complete).

    I created a pivot table , but since you are not able to calculate a median from within the pivot table, I created an array calculated field that displays the calculated median. So in this Pivot table I now have the date, minTime, maxTime, and the foreign Median. I try to create a line graph to plot all three values per month, but only the minTime and maxTime display on graph.

    Please assist. I have attached a sample
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-24-2017
    Location
    usa
    MS-Off Ver
    Office Pro 2010
    Posts
    2

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

    This is a hard one right??

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

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

    This proposed solution adds a column to the data that finds the median by month using the formula: =MEDIAN(IF(A$2:A$100=A2,C$2:C$100))
    The resulting pivot table and pivot chart is then shown on Sheet 1.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Median value within a pivot table
    By Bee in forum Excel General
    Replies: 3
    Last Post: 05-15-2006, 06:45 PM
  2. How can I put the median on a pivot table?
    By JAH in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-22-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1