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!

 

Capture.PNG

5 Replies

@SharonLouise 

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

 

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

@SharonLouise 

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.