Graph type - Categorial

Question

Hi All,&nbsp;When I chose categorial type under line graph, scroll button appears in the bottom.&nbsp;How can I get rid of it as I want to see all range all at once.&nbsp;For example, I want to squeeze 1 Jan 2017 till 1 Dec 2017 (in Width 900 , Height 600) without scrooling .&nbsp;Appreciate your help!&nbsp;All the best,cocomy&nbsp;&nbsp;

rocky09 · Answer

one way is to change the font size of X axis and other way could be formatting Date as mm/dd/yy. Just an idea.

cocomy · Answer

rocky 09,&nbsp;Thank you very much for your advice. I tried your recommendation.&nbsp;I still have to scroll to see all at once.&nbsp; Appreciate if you can come up with another idea!&nbsp;All the best,cocomy

rocky09 · Answer

Can you post a screenshot?

cocomy · Answer

Hi Rocky 09&nbsp;Here is an exapmple. I would like to show Jan 2017 - Dec 2018 without scrolling.&nbsp;Is it possible to squeeze ?&nbsp;I like to use line with marker, I need to select categorial in this case.&nbsp;All the best,cocomy&nbsp;&nbsp;&nbsp;&nbsp;

rocky09 · Answer

cocomyYou are trying to see all (365 days) in that graph. I don't think, you can see day by day data without a scroller.&nbsp;Work around 1: Just Put Date on X-axis (Without Date Hirarchy) and then go to format then Change the X-axis&nbsp; Type to Continuous.Work around 2: You can use Drill Option with Date Hirarchy, So, you can drill down the data without a scroller.&nbsp;&nbsp;

Forum Discussion

Graph type - Categorial

5 Replies

Related content

Bar Graph - 2 Different Categories

Category Hierarchy for graph legend

Bar Graph Category

Type Mismatch

Transform columns / type