X-axis values repeating themselves

[telepet]

X-axis values on my chart are repeating themselves.   In the attached example, I have four courses, all of which are either 3 or 4 credit hour courses.  I'd like to have values 1, 2, 3, 4 but instead I'm seeing each number multiple times.   I should note that I am formatting the X-axis values to be number type, with a comma.

 

I've experimented with taking away any formatting for the X-axis value but then I get decimal numbers (see attachment).

 

Is there a way to just have a 1, 2, 3 and 4 in this example?

[jhernandez]

Hello,

We'll need to see how your source data looks like. In the most simple terms, the data table should be set to have one X value per each Y value. That or it's somehow rounding numbers down like 2 then 2.5 rounded down to 2.

[telepet]

14 hours ago, jhernandez said:

Hello,

We'll need to see how your source data looks like. In the most simple terms, the data table should be set to have one X value per each Y value. That or it's somehow rounding numbers down like 2 then 2.5 rounded down to 2.

Thanks for your reply.  Source data is number data type, so decimals, but consists only of 1, 2, 3, 4, or 5 values (so 1.0, 2.0, 3.0, 4.0, or 5.0).  I wonder if I should used a different data type for this column.  I'll investigate...  thanks again.

[jhernandez]

On 8/16/2017 at 4:10 AM, telepet said:

Thanks for your reply.  Source data is number data type, so decimals, but consists only of 1, 2, 3, 4, or 5 values (so 1.0, 2.0, 3.0, 4.0, or 5.0).  I wonder if I should used a different data type for this column.  I'll investigate...  thanks again.

It may be a setting with the chart itself than your data it seems, but I can't be sure since I've never seen anything like this.

I suggest checking the style you are using for your charts too, and the chart setting in Datapage itself. There may be a setting that is asking how you'd like to display the units on the Y Axis. For example, instead of saying you want the unites to increase by one, Caspio may be trying to go in 0.5 intervals and then round up/down.

Anyway, let me know if you can solve this one and I can try testing.