+ Reply to Thread
Results 1 to 1 of 1

Syncing Timeline From-To Dates With Cells

  1. #1
    Forum Contributor
    Join Date
    04-23-2014
    Location
    United Kingdom
    MS-Off Ver
    Microsoft 365
    Posts
    149

    Syncing Timeline From-To Dates With Cells

    I have a pivot table that is linked to a timeline widget, allowing the user to manipulate the table based on their date range selection. I've also allowed the user to manually type in a a 'Date From' and 'Date To' value, and this refreshes the pivot table whenever there's a change. This works as far as the table updating goes, but it does not synchronise with the timeline.

    So…I need a solution whereby the date range in the timeline always matches the date range in the cells — and vice-versa.

    I've attached a workbook to demonstrate what I mean.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Timeline on Pivot where dates are the header
    By 03staylo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-06-2016, 02:19 PM
  2. Syncing two cells in different worksheets
    By skyraev in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-07-2015, 06:04 PM
  3. Syncing Intelligent cells
    By dogie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2012, 06:10 AM
  4. Excel 2007 : List of Dates, Events & Timeline
    By MarcjGriff in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 06:29 AM
  5. How do I use the excel timeline function with dates in graphs
    By sweet4511 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  6. [SOLVED] How do I use the excel timeline function with dates in graphs
    By sweet4511 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] How do I use the excel timeline function with dates in graphs
    By sweet4511 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1