topic Re: Numeric values in wrong order on axis in Discussions

Numeric values in wrong order on axis

GZ78 — Mon, 02 Jul 2018 18:31:21 GMT

I am trying to plot some data in graph builder, but the numeric values (x axis below) plot in order of the number while ignoring the decimal place. I am plotting overlays that use the same 116 numeric categories on the x-axis, so dragging these values manually is not efficient. The values are in the correct order within the data table. What settings can I use to maintain either the order assigned in the data table or force them to read from smallest to largerst without ignoring the decimal place?

Re: Numeric values in wrong order on axis

Dan_Obermiller — Mon, 02 Jul 2018 18:45:46 GMT

If you make your x axis variable continuous, I believe that would correct the problem.

Re: Numeric values in wrong order on axis

GZ78 — Mon, 02 Jul 2018 19:05:08 GMT

I had already assigned it as continuous. I reattempted that and I get the same issue. I have also tried fixing the decimal places to three. (for example values with 0.001, 0.010 and 0.100). Neither of these seemed to work.

Re: Numeric values in wrong order on axis

Dan_Obermiller — Mon, 02 Jul 2018 19:15:21 GMT

Perhaps you have a value ordering property turned on? Any chance you could share some of the data?

Re: Numeric values in wrong order on axis

GZ78 — Mon, 02 Jul 2018 19:23:28 GMT

We were both headed in that direction. There was a value ordering setting already applied in the data. I removed this and reset all the column settings. I am now getting the plot I need. Thanks for the help, Dan!