timeline

Dear Experts, I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria. 1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days. 1st Day Plan: 25% of...

Hello everybody. I've the following table: https://imgur.com/D8BG8cM I need to represent these data in a line chart this way: - on horizontal axis, YEAR - on vertical axis, ALPHA and BETA (in order to compare them on a timeline). How can I set the axes?

Hi there, I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which...

Good afternoon, Thanks for having a look at this. I am trying to build a "team task tracker" like the below Column B "Employee name" Column C Macro button which when pressed as a row bellow "button row" The new row has...

Hi Guys, I have created an automated timeline in Excel and but I would like to have conditional formating between the starting date and the end date: https://ibb.co/WfnjvPq I would like to be shown as a bar basically, thus the cells in between SD and ED shall be automatically yellow. Perhaps...

I recently started using the Insert Timeline function for Pivot tables. However, generally I just want to choose today's date as my filter for the pivot table. Thus, the Insert Timeline is a bit cumbersome since first I have to choose it, then choose date, then month, then actual day. Is there a...

Hi, Is there a way to limit the range of a timeline created in Excel? The issue in my file is that the timeline date starts at 01 Jan 2017 and ends on 31 Dec 2018, but my data cover only from Nov 2017 to march 2018. Thanks. File: https://ufile.io/sov2w

I have a Timeline that has a number of connections to Pivot Tables that are driving several charts. I need to report on the dates selected via the time line but I am unable to get the CUBESET functions to work. The Timeline is labelled as DateReceived where the shape can be named (same place...

Hi there! I'm having some issues with the timeline slicer for a pivot table. I have created a relationship between several sets of data, with multiple dates. Each set of data corresponds to a specific "Influencer." When sorting dates using the timeline splicer, it correctly pulls information...

I have the below Pivot table (it goes through to zone 8), The data in the columns is number of people in an area at a given time. I would like to add a scroll bar connected to the pivot to filter this table (a total of 17 positions) i.e. position 1 showing 06:30 and position 2 showing 07:30 etc...

Hi All, I have a pivot table that uses the excel timeline feature. I have the appropriate column formatted as date and it has been working perfectly up to this point. However, it has just suddenly stopped working and I get the error message that I have no columns in date format. The workbook...

Hello, I have had zero luck trying to build a timeline chart mainly because I have no idea what I'm doing. I appreciate any and all assistance. My worksheet is working correctly in generating the correct times per task. Data is built in the following format: Task Event Start...

Hi, I have the below code which clears the slicer filters fine but for some reason isint working on the timeline filters. Would anyone know what I need to add to clear the timeline filters? <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

<tbody> Task Start date End Date No of Days Preparation Mon 30/07/218 Mon 06/08/2018 5 Blueprint Tue 07/08/2018 Tue 07/08/2018 1 Realisation Wed 08/08/2018 Fri 10/08/2018 3 </tbody> Hi Gurus, In the absence of Microsoft Project, i'm trying to make a timeline based on...

Hi, I used a 2D stacked chart to plot art as Gantt chart. However, what I need is a timeline plot. For example, in the sheet HERE, the 5 horizontal bars (Team 1 - Team 5) they all should be in one row and not 5 different rows. Any suggestions on how that could be achieved. The purpose is to...

Hi, I wonder if there is a way to filter/slice a pivot table in the exact same way that a timeline-slicer works, but with manually entering dates instead of marking them on the timeline. I want it to function as a slicer in a dashboard-worksheet. Like the "Date Filter -> Between" but as a...

Hello everybody. I'm approaching a work, and I would like some good hints to proceed. In the image an example (actually I have thousands of rows to elaborate). https://imgur.com/a/AQwvOR3 In the scheme, for any single code I have elaborated a sort of timeline. Now, I have to set something...

Hello, I used a scatter plot to create a time line. It is based on a dynamic data. Every time I change the data set to show a different project, I have to readjust the graph size to make it smaller or larger based on the size of the data set. Does anyone know if there is a way to have the...

This is one of the most bizarre issue with Timeline slicers. It has existed ever since Timeline slicer exist (incl. Ms Excel 2013 and 2016). I have searched for solutions, none of which I found suitable. So here is mine: Problem: You have a timeline slicer, when the sheet is protected, it works...

Hi. I just started playing with DAX formulas and Power Pivot. I would appreciate any hints on how to do the following: There is a list of stores (green table) with a sales value for a date. I added this table to the data model and created a Power Pivot. Using the measure: Months by...