Problems with the Y axis values

[dagagnon]

Hello,

I got a strange problems with some bar charts were the Y axis values are repeating themselves instead of showing different values.

It's almost like all the series had different kind values, which isn't the case.

I got things like 3 3 2 2 1 1 on my Y axis and I have 2 collections :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It works well with xlLine, xlBarClustered and xlPieExploded

I don't have problems with them. Do you have any suggestions on how fixing that problem. Sometime it works , sometime it's not...

[JosephP]

it sounds like you need to have decimal places shown-it's probably plotting 1, 1.5, 2, 2.5 but you have the axis set to only show integers

[dagagnon]

it sounds like you need to have decimal places shown-it's probably plotting 1, 1.5, 2, 2.5 but you have the axis set to only show integers

Yeah, that's right. I didn't thought it was rounding my numbers automatically, this was indeed the problem, thank you !

I don't get it, how am I suppose to inndicate that this problem has been solved ?

[JosephP]

how to mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save