Auto Chart incorrectly showing decimal on vertical axis

Kenneth Jones shared this question 2 years ago
Answered

I have an auto chart that is showing decimals on the vertical axis and it should be whole numbers. In the data section I put round up and the data does not have any decimal values. If I try to change it to vertical charts it works but it will not let me add a non numeric colour.

Comments (3)

photo
1

Hi Kenneth,

Typically this is controlled by the amount of decimal places in the report formatting. You mention that you have this set to round up, have you tried setting the decimals places to 0 specifically (in this same menu)?

Regards,

Nathan

photo
1

I attached a file with the details. let me know if you have more questions.

photo
1

Hi Kenneth,

In this case, the auto-chart is hard to adjust, so it will be better to get the normal vertical column chart working so you can manually set the scale units.

To use dimension colors, you will need to convert the report into cross-tab format. I would reccomend placing category in the "rows", and category sub type into "columns' and going from there.

Let me know if this makes sense or doesn't work.

Nathan

photo
1

Yes, that worked. Thanks!!

photo
1

Awesome, no problem!

photo