Timeline Issues on a Pivot Table

[SharonLouise]

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!

[#2]

@SharonLouise 

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

[#3]

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

[#4]

@SharonLouise 

3 date/time fields:

Start of Un...

End of Un...

Total Un...

Choose one or more of them for your timeline.

[#5]

Thank you for your reply, I am actually wanting the "date" i.e. MArch, April, May etc???

[#6]

You have to choose one of date/time fields first.