Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started