How To Create a Pivot Table Timeline in Excel 2013

how to create tmieline 1 lead 675403

If you’re tired of manipulating dates in your pivot table using clunky filter tools, Microsoft has finally provided a better way. Pivot table timelines allow you to quickly shift your pivot table according to dates and time, as well as zoom in and out of specific time periods. Fortunately, adding a timeline to your pivot table is no more difficult than a few clicks of the mouse. Just follow these steps to get started.

1. Click inside the pivot table to bring up the PivotTable Tools.

how to create tmieline 1 click pivottable 675403

2. Click “Analyze” at the top of the screen.

how to create tmieline 2 click analyze 675403

3. Click “Insert Timeline” in the Ribbon.

how to create tmieline 3 click insert timeline 675403

4. Select the date you wish to use and press OK.

how to create tmieline 4 select date 675403

5. Adjust the timeline using the filter button. You can choose from Years, Quarters, Months or Days.

how to create tmieline 4 adjust timeline

LEAVE A REPLY
Name*
Email* (will not be published)
Website
*Indicates required field
Comments*
Submit Comments

  1. Marilyn Williams Says:

    Great information!!

    But how about taking it to the next level? It would be greatly appreciated if articles like these included a file to download with the sample data so that we could play with it.

FIND A REVIEW
Laptops
All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Brand
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
Resolution
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options
SUBSCRIBE