Question: On excel version 3 5 6 Using regular table on excel analyst data by pivot table so my data does not have year or month

On excel version 356
Using regular table on excel analyst data by pivot table so my data does not have year or month or quarter headers on regular table but i have data like 3/4/2023 so
I inserted table pivot then i inserted chart and i inserted timeline and choose date from my table but there is problem i want show me the year and quarter and month all it to chose it and appears al like year quarter month and chose year then the timeline change to year and if want month choose month but not to click on timeline option and chose year or quarter or month or day to switch between them No i want to appear all it and chosen one of them i want to achieve one timelines show me year and quarter and month then I choose year then it shows me 2022,2023.2020 like that I dont know maybe i need 2 timelines or not but how can do it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!