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
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 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 like that I dont know maybe i need 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
