Nov 06 2017 03:13 AM
I am interested in the Timeline feature which is in Excel 2016 - on the Insert tab > Filters > Timeline. I expected it would be a simple case of adding some dates and data, but I can't even get off the ground with it! It seems to be requesting a database when I click on it. I thought it might be like Slicers, and would only work if my data was in a "Table", so tried that, same result, it displays an "Existing Connections" dialog box.
Any help appreciated!
Steve
Nov 06 2017 03:22 AM
Hi,
Timeline slicer works with PivotTable https://support.office.com/en-us/article/Create-a-PivotTable-timeline-to-filter-dates-d3956083-01be-...
Nov 06 2017 03:52 AM
Hi Sergei
thank you for the fast reply. I'm OK with it now . . . didn't think it would be difficult once I knew how to start it off.
Thanks again!
Steve