timeline

Hi All, I have a spreadsheet that I use to organize projects and their budgets/timelines etc. I have a large, static timeline that goes for a couple of months with each column header being a dd/mm/yyyy date. Additionally, I have budget data for specific projects under header names such as...

Hello, I have been asked to make a specific timeline and I am having trouble creating it. The attached picture is similar to what I need...

Is it possible to obtain a timeline slicer value in a cell ? or even better yet to use in a Footer ? I am only using slicer on a Monthly purpose and would like to format to see as January - 2018 Thanks

I use this code in Access to draw a timeline and freeze panes in Excel - so the commands are for the Excel enviroment - that's why I'm asking here. Sometimes it runs into error 1004 in the marked line: Private Sub bygTidslinien(st As Integer, d As Boolean) Dim xlApp As Object Dim wb As...

Hello everyone, I'm not sure if it is the place, but i stumbled upon this, while making dashboard with timelines, where i want to pull timeline selection into different cell using Cubeset and Cuberankedmember, but the problem is, that date formatting comes in as american standard...

Good afternoon, I'm hoping to get some advice on a timeline slicer. I would like to exclude a specific month (or range of months) from a timeline selection, but from my attempts, it doesn't seem like this is possible within the Timeline slicer. Example: I need to know average sales for 2017...

Hi Guys, I have searched everywhere for the past two days to find an answer/code to help me with. I have a timeline inserted based on a pivot table. I have protected the sheet and I am able to use the slicer etc. But When I protect the sheet: 1) I want to be able to use the timeline year...

Hello there everyone! Im wondering if its possible to do this or not, or maybe some way i can achieve this. What i want to do is make a few groups of a few columns each in a pivot table, and then be able to use a slicer or timeline to be able to select which of the groups i want to see at any...

I've searched to find the answer and cannot get any solutions to work for me. I'm running sumifs in a workbook to reference a closed workbook. It works fine with the referenced workbook is open, but as soon as it is closed, I get the #Value error. Here is my formula: =SUMIFS('[Location...

My work uses sharepoint to create schedules, but the sharepoint interface is sometimes buggy and requires an internet connection to do work. We've created an excel spreadsheet that is editable offline, and that uses a formatted worksheet for the user to enter data. This then reorganize cells...

In the following code when setting the variable "Timeline", it's correct, for example "2017-03-10" but in R1C1 formula it's displayed as "2017-3-10". I changed Timeline in R1C1 formula to Format(Timeline,, "yyyy-mm-dd").No effect. Do you have an idea what I am doing wrong? Dim Timeline As...

I have a document that I list time blocks for separate locations during a specific timeline. I would like to link those time blocks to a different document that has a timeline across the top and the rows beneath will populate the time blocks automatically. I have multiple users submitting time...

Hey guys, hope you are all doing well. I have a problem on my hands I simply cant solve. I attached a dropbox link to the file, where you can easily see it. What i am trying to do: - on sheet 'timeline', i.e. column C: take cell A2, go to sheet 'test' column A and search for the value. If you...

HI, I am looking for a template based on projects in my hand. Can anyone suggest a way out pls? Project Name Description Start date End Date Status A...

Hi, I have a tool I've developed in Excel that ends up building a particular 'timeline' out. Its columns look somewhat like the following: ActivityID Description Duration StartDate EndDate It builds out this 'timeline' using inputs gathered from the user in an excel userform, and then...

I would like to return the date ranges for which products were substituted but I'm having difficulty with the filters. I have a "sub" flag in my Orders table that indicates if a product was substituted (the product ID is different than that in our item master file). I have a calendar table...

Hello all of you wonderfully brilliant Excel experts!! I hope you can help... I need to create a chart/graph (whatever will do what I need, fairly easily) to show the active & down times for multiple companies. I tried using a bar chart, but I'm not able to tell Excel how I want the...

Hi, Relatively new to Pivot tables... I am trying to develop a pt report based on an exported datasheet from Access. The Date field in the database has been formatted to short date (9/26/2016). When I put the pt to work, all the dates show up on the column headers properly, but I cannot seem to...

Howdy, I am using Power Query to merge tables from several excel files into a master table. In these source tables there are two date columns A and B. Date column A contains only dates. Column B contains blanks, dates and sometimes text - always the text "Enter Date" When I import the...

I am trying to set a Timeline date range using VBA. sub DateTest() Dim sd as Date Dim ed as Date sd = Sheets("Stuff").Range("B11").Value ed = Sheets("Stuff").Range("C11").Value Sheets("Charts").Shapes.Range(Array("Date6")).Select...