Timeline Issues on a Pivot Table

New Contributor

Hi All


Can someone please help me, I am trying to insert a timeline on the below pivot table but as you can see I cannot see the "date" in the insert timeline box?  I have the dates set out on a spreadsheet in a normal column, normal date set up etc.  Hope someone can help.  Thank you!



5 Replies


Excel has found 3 date/time fields. Choose one or more of them.


Hi, my apologies I am unsure what you mean??


3 date/time fields:

Start of Un...

End of Un...

Total Un...


Choose one or more of them for your timeline.


Thank you for your reply, I am actually wanting the "date" i.e. MArch, April, May etc???
You have to choose one of date/time fields first.