Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions