timeline

  1. H

    converting a formula to be read as date format for sorting Pivot tables by date using timeline.

    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...
  2. E

    Help with monthly average

    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...
  3. D

    Convert a vertical task list into a timeline (horizontal)

    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...
  4. D

    Using Timeline Slicer

    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...
  5. Bagharmin

    Changes in Timeline don't affect Slicer

    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...
  6. M

    Return Timeline Selection

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

    Create a filter for a slicer based on if the sum of values is not equal to zero when a timeline changes

    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...
  8. L

    Dynamic naming of timeline

    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...
  9. U

    Accessing NativeTimeline using Cube functions

    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...
  10. U

    Get date details from Timeline

    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
  11. K

    Timeline Conditions

    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...
  12. Nelson78

    Chart: arrange values on axis

    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?
  13. A

    Timeline Connection to Slicers visually indicating items with no data

    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...
  14. F

    Dynamic timline

    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...
  15. L

    Timeline Conditional Formating

    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...
  16. D

    Pivot Table Timeline

    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...
  17. M

    Limit range of timeline - Excel

    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
  18. M

    CUBE function/s to return Timeline selection

    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...
  19. S

    Power pivot timeline slicer not pulling all data

    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...
  20. V

    Creating a Scroll bar to filter a Pivot Table (By Time) Excel 2010.

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top