Timeline Issues on a Pivot Table

Question

Hi All&nbsp;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?&nbsp; I have the dates set out on a spreadsheet in a normal column, normal date set up etc.&nbsp; Hope someone can help.&nbsp; Thank you!&nbsp;

detlef_lewin · Answer

SharonLouise&nbsp;Excel has found 3 date/time fields. Choose one or more of them.&nbsp;

sharonlouise · Answer

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

detlef_lewin · Answer

SharonLouise&nbsp;3 date/time fields:Start of Un...End of Un...Total Un...&nbsp;Choose one or more of them for your timeline.&nbsp;

sharonlouise · Answer

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

detlef_lewin · Answer

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

Forum Discussion

Timeline Issues on a Pivot Table

Share

Resources