timeline

Hi all, I am trying to add a timeline to my spreadsheet to allow users to adjust the date period that they want to see data on. I will try to break down how my data is being constructed: Workbook has 2 sheets. Dashboard & Sheet1. In Sheet1, I have a table named WIP_RAW which is pulled from a...

Hello I have a lot of messages (300 approx) between myself and my bank that span a 1-2 year period. I want to enter all these messages into some sort of timeline, chart. That starts from the first message and progresses thru to the last message. I guess some sort of excel flowchart, or message...

Hi all, I am wondering if someone is able to help me out to create a visual that would look like this below (I found a topic somewhere else with same request I need today. couldn't find answers about it so I come here to check if there's luck Power BI Stacked Bar as Timeline with Milestones)...

Hello all, I require a little help with forecasting the 'cost' per day based on a timeline. I have created a project timeline which each row (task) has a start and end date. Each task has a value (cost). Each task requires a 20% deposit, 4 weeks before the start date. The remaining 80% cost...

Hello all, I hope this isn't a repeat question (I searched beforehand) but I would like to create a planning chart where I have a start date column and end date column and have those dates and everything in-between filled in with a color on a timeline. This would speed things up and eliminate...

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...

Hey all, I asked a question similar to this the other day, but have changed my approach and wanted to get some input. Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...

Hey all, I'm building a collection of very high-level project timelines for a quick snapshot of where a project currently stands. This is all based on the dates / date ranges I'm given by Project Managers, and then have to manually extend and move the visual timeline references around. *Edit*...

Hello, I work in the construction industry and I've created a schedule that tracks 8 separate task/deadlines for multiple projects (the task are the same for each project but the projects have different start dates.) The timeframe for each task will always remain the same with event A happening...

Hello all My question is related to charting a set of data in a specific way that I can clarify as we go on, but the jist of it is included below, I am in a bit of a pickle with a task I have to convert some MATLAB code into VBA. Usually my methodology to do this is to develop each chart...

Hi, I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot...

Hello all, after hours spent trying to find a solution online, which was unsuccessful, I decided to post a new thread and see if anyone could help me out. I have multiple pivot tables connected to timeline slicer where user can select time period to view data set. I found online how to get...

Hi All, I don't know if this is easily do-able or not: I have a vertical list of tasks with sub tasks that have to be completed at a certain time before the project end date. To make it easy, I would like to convert these items to a horizontal timeline which displays the tasks and sub tasks on...

I have a table that has multiple columns formatted as dates. When I try to create a Pivot Table and insert a Timeline Slicer, it is only giving me the option to use one of the columns (Reworked Date) and it's not the one I need (Date Initiated). The purpose of the Pivot Table is create a report...

I have a Timeline and some Slicers connected to a pivot table. The pivot table uses data obtained via Power Query and loaded to the data model via a connection only (I'm probably not saying this entirely correctly). Whenever I change the Timeline, the changes are reflected in the pivot table...

Is it possible to either return the Label Selection or the periods selected from a Timeline attached to a pivot table?

I have a general question about how to set up a slicer used with several power pivot charts. I have two charts that share a timeline and display company totals and I have a slicer that allows for individual vendors to be selected. Everything works as intended, the only problem is that for this...

Hi as per the dropbox link, i have a simple timeline that i want to have certain values appear according to their month. https://www.dropbox.com/s/4hke17yf0eohmya/Build%20timeline.xlsx?dl=0 So for example, construction starts 01 Dec 2019, i want the text "Construction Starts" appear in J9...

Hi, Firstly, apologies I am not an advanced Excel user, so please excuse any obvious gaps in knowledge. Essentially, I am using a TimeLine to select a month that adjusts Pivot table information - easy enough! However, I need to extract the month selected in order to apply to a simple...

Hi, I have built a scrolling timeline to select a month, but I would like to get month that has been selected to incorporate into another formula - is there a way to do this? Would appreciate any advise. Many thanks Ian