Jump to content
  • 0

X-axis values repeating themselves


telepet
 Share

Question

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?

testChart.jpg

decimalExample.png

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...