In a PivotChart filter, how do I select a just range in the column to display?
Jennifer Carner
Help! I have created a pivot chart that shows 3 data series across iterations (time). All series are shown as 'running total in' base field: iterations.
The series are:
- Total Hours Planned
- Capacity in Hours
- Completed Work
They would like to see the series Total Hours Planned and Capacity in Hours through the end of the year, but Completed Work only through the current iteration. Not sure how to apply a filter only to one series and not to the others? This will be widely used so I am trying to keep it as simple and/or automated as possible. Ideally they'd like a trendline that starts at the current iteration to predict completed work through the end of the year... but I'd settle for filter. (updated to align with new titles)
Sun
There isn't an easy way partially display column data. It'd be easier to set up a separate sheet that looks up the Data from the PivotTable, do some additional logic on it, then display a PivotChart from the processed data.
Here's what I did based on your screenshot. I copied the data and added two more columns called Show? and ShowCompletedWork. The formula for ShowCompletedWork is =IF(E2="yes",B2,"")
I think others have used the OFFSET function to do what you want, but seems like a lot of effort.
Date,CompletedWork,Total Hours Planned,Capacity In Hours,Show?,ShowCompletedWork
19-Apr-2016,1000,1200,2500,yes,1000
3-May-2016,5000,5000,5000,yes,5000
17-May-2016,7000,7500,7500,yes,7000
31-May-2016,8000,8500,10000,yes,8000
14-Jun-2016,8000,10000,12500,,
28-Jun-2016,8000,15000,15000,,
12-Jul-2016,8000,17500,17500,,
26-Jul-2016,8000,21000,20000,,
9-Aug-2016,8000,27000,22500,,
23-Aug-2016,8000,31000,25000,,
6-Sep-2016,8000,37000,27500,,
20-Sep-2016,8000,40500,30000,,
4-Oct-2016,8000,46000,32500,,
18-Oct-2016,8000,49000,35000,,
1-Nov-2016,8000,52000,37500,,
15-Nov-2016,8000,53000,40000,,
29-Nov-2016,8000,55000,42500,,
13-Dec-2016,8000,59000,45000,,
27-Dec-2016,8000,61000,47500,,
I created a PivotChart from that data:
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: xclock not runnnig for another user
- Next: trying to connect to eduroam with wicd or wpa-supplicant fails
Related
Related Related
- 1
How do I just select the "occupation"?
- 2
How do I filter date range in DataTables?
- 3
How do I select a range of cells in without giving the range a name?
- 4
How do I select a range of cells in without giving the range a name?
- 5
How do I display just the html tag in JSoup java?
- 6
How do I just display the value for the variations in woocommerce email?
- 7
How do I just display a table header if a jsf datatable is empty?
- 8
how do i filter a column with multiple values
- 9
How can I use an AngularJS filter to select rows from a range?
- 10
How do I select just mutual rows in SQL?
- 11
How Do I Select Just a Latitude or Longitude From A Geography Point
- 12
How do I insert two values in mysql with just one select?
- 13
How do I get just the first quartile from a column
- 14
How do I remove dot and number in just one column?
- 15
How do I prevent a PivotChart from becoming a regular chart on sheet copy?
- 16
How do I select a column using an alias
- 17
How do I filter an array based on a range of numbers?
- 18
How do I filter out SQL rows where numbers range?
- 19
How do I filter a pivot table by a date range?
- 20
How do I select a range of elements in Spark RDD?
- 21
How do I select a range of two numpy indices?
- 22
How do I select subrange from a range object in VBA?
- 23
Why i am getting different result just on increasing a column in Select clause, how can I solve this?
- 24
I want to bypass the headers and have just the sum of the amount column, how do I do that?
- 25
How do I display an image that I just took from my camera in my android app?
- 26
how do I filter properties from an entity using select() of Linq?
- 27
How do I change my column sort to sort the entire sheet not just a column?
- 28
How do I change my column sort to sort the entire sheet not just a column?
- 29
How do I filter a table in Excel based on a column of values?
Comments