timeline

I am trying to lock down the "Timeline" slicer from being moved and resized but still allow the user to adjust it. I know with all other types of slicers you can check the box under position properties "Disable moving and resizing." When I look at the position properties for the Timeline it...

Hello, I am working on an Excel project that lists the timeline for certain tasks. I have most of the design created but need help with the advanced formulas that will make it dynamic and work correctly. I would greatly appreciate it and thank you for your time in helping me. I will list my...

Hi, I'm sure this question must have been asked before, I have searched and can't find the exact answer; I know how to link a chart title to a given cell so it becomes dynamic, but not to a pivot chart timeline. I have some pivot charts with slicers & timelines that work absolutely fine, but I...

I have a worksheet with a table that contains 7 date columns. All of the columns are formatted as Date like this: When I create a PivotTable I'm only able to select four of the columns as Timeline and I have no idea why I can't select the last three. I have tried to reproduce the error with...

Hi, I'm working in Excel 2010 and I would like, to some extend, to replicate the Timeline Slicer of Excel 2013. I have date field from which I have created 5 columns which checks if the date in column A is Today, Current Week, Current Month, Current Quarter and Current Year as shown in the...

Hi I have two pivot tables and I want to be able to control date ranges in those pivot tables with a timeline slicer. The problem is I want to control them based upon different dates (Different fields in the raw data). So I want to select 01/01/2016 based upon date1 in one pivot and 01/01/2016...

I have a pivot table (derived from PowerPivot) that displays data filtered by a Timeline Slicer. The Pivot table is then represented in a Pie Chart which has a title. Is there any way I can link the title to the Timeline Slicer range, so it indicates the date range for which the pie chart is...

Hey guys, I have created a dashboard with multiple pivot tables, slicers and timelines. I have been able to fix it so the slicer connections will allow me to drill down into the data, but I cannot get the timeline function to do so. For example: when i use all the slicers and timeline for 4th...

I'm working in Excel 2013 for windows. I 'm wondering if there is any way that I can take a table that tracks 4 different types of events for each record(row). What is the best method to get all of the events for all records placed into one chart where the horizontal axis is a timeline...

Hi I am looking for a bit of help on a graphical representation of some processes over a 15 hour period for a 2 day sample period ( I will extend this out further , when resolved) The end user when looking at this data should easily be able to see: - how long each process took for each of the...

I would like to colour blank cells depending on the date change in a different cell. Please see table below *** an example. <TBODY> ACTIVITY START FINISH 07-Jul-14 14-Jul-14 21-Jul-14 28-Jul-14 04-Aug-14 11-Aug-14 A 29-May-14 07-Aug-14 B 05-Jun-14...

I keep getting the error: "We can't create a Timeline for the report because it doesn't have a field formatted as Date". I thought that this must just be a simple formatting issue and so I went back and took my column with the dates and formatted it as "Short Date", and got the same error. I...

Hi! I'm in greatly need of help. I'm currently working on updating a timeline for airplane flights in Excel, and I've met a wall (I've never used excel before). I use macros to add flights and change the status of a flight. Everything of the timeline is made in the cells in a worksheet. I dont...

hello all - what i am trying to do is take the values from a timeline slicer and use them in an IF statement. the formula would look somnthing like this in excel =if((Date)=(Slicer_Datekey),True,False) the slicer_datekey could contain multiple dates. any ideas on how i would approach this? thanks

Hi All, Bit of background: Using a pivot table to filter different projects titles by client in a data base. Looks a little like: 'Client X' is in the pivot table filter and the 'Project Titles' is in the pivot table row. Dates are all decided though an index-match formula. I'm using the...

Hi, I have costs over a timeline in months with their assosiated quarter and year numbers like below on a seperate row underneath the month row: Month 1 Month 2 Month 3 Month 4 etc etc Y1 Qtr1 Y1 Qtr1 Y1 Qtr1 Y1 Qtr2 etc etc Monthly costs........................ etc etc What I need to do is...

Hi everyone, I asking your help since I can't find a solution. I am working on a Financial scorecard. I am using Excel 2013 with powerpvot. I want my users using the new feature timeline since it is really sharpe. However, when someone select 2014 January, I also want 2013 January in order to...

Hi, I’m trying to find the appropriate format for the following shared spreadsheet. 1. I need to be able to filter by different fields, primarily Location or Month, without breaking the timeline or breaking the subtotals and grand total. 2. I need to be able to easily add or remove SKU’s...

Hi all, I just got into the world of PowerPivot, Excel 2013 and Pivot Tables and am in the process of creating a Dashboard which I will then be uploading to SharePoint 2013. On top of page I added the new timeline filter which I've linked to my pivot charts. Now what I would like to do, is...

Hi guys.... I have a Workbook (Excel 2010) with several Worksheets - each Worksheet represents a business loan, and each loan has a different start and predicted end date. On each worksheet I have a column with the Next Payment Date, and another column with the Balance after the payment has...