cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Hide 0 from X axis in continuous order while there is no 0 in data

Hi, I need to plot test values vs Study Days for multiple patients in scatter plot. Showing test names in filter. There are negative studydays as well and
no possibility of '0' study. Patient Id need to use in legends Study days can be only in -ve and +ve numbers. But when I'm ploting it by keeping X-axis in continuous,
It's showing 0 study days and when trying with catogorical, study day is not coming in order.
Is there any way to plot study day in X-axis in order without showing 0.
Please refer the attachments.

Thankscategorical type.JPG0study day.JPG

9 REPLIES 9
Highlighted
Anonymous
Not applicable

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Jyotisha,

 

Have your tried chaning your X Axis from type Continuous to type Categorical (looking at the second screenshot here)?

 

Logically speaking, when traversing from negative values across to positive values, zero is a very relevant reference point.

 

Based on your screenshots, it's clear to me that despite the fact zero is shown on the axis, there are no data points attributed to it.

 

Cheers,

Andy

 

Edit: Spelling

Highlighted
Resolver I
Resolver I

Re: Hide 0 from X axis in continuous order while there is no 0 in data

That's such a random order for the X-Axis to display!

 

Can you check that the Study Day data type is set to "Number" rather than text.

 

Also, check the "Sort By Column" option to make sure it's not being sorted by a different column.

Highlighted
Frequent Visitor

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Anonymous ,

Appreciate your quick response.
As We are considering the ​test results from the past when we didn't start the study. study day 1 is considered from the day we are starting study. So practically there is no possibility of 0 studydays. And I need to show studydays in ascending order only.

Highlighted
Frequent Visitor

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @martynbooth88 ,

Appreciate your quick response.

Data type of Study Day is Whole number only. I have also checked "Sort By Column" option but It's not affecting it.

Highlighted
Community Support
Community Support

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Jyotisha ,

 

Are you using the Scatter chart ? Could you please try to change the range of Y-Axis from 0.2 to 1, it will make the chart more clearly.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @v-lid-msft , 

Actually the axis value varies test to tests. And there are various tests, provided in the filter. So we cannot fix the axis.

Highlighted
Frequent Visitor

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Anonymous , 

Appreciate your quick response.

I also tried the same but then study days are not sorting on order. Please have a look on attachmet for categorical.

Highlighted
Community Support
Community Support

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Jyotisha ,

 

Sorry for delay in response, in the scatter chart, the x-axis will group by the legend first, we can try to use a line chart wiout line as a workaround:

 

6.jpg7.jpg

 


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support
Community Support

Re: Hide 0 from X axis in continuous order while there is no 0 in data

Hi @Jyotisha ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors