Is there a way to get rid of the decimals in the below chart without reverting to grid form first?
Best answer by Benoit
View originalIs there a way to get rid of the decimals in the below chart without reverting to grid form first?
Best answer by Benoit
View originalHi,
Charts values reflect the grid. So you’ll have to go on the grid view in order to remove the decimals from the format panel.
If you would like a different behavior, I would recommend to create an Idea. This feedback will be reviewed and eventually considered for future improvements.
Many thanks for your help and valuable ideas!
Truly means a lot to us for improving our Product and Services!
Best,
Benoit
Hi
I can’t see that it works the way you are describing. I have a bar chart that shows decimals for both bar labels and values on the y-axis. It doesn’t help to change visualization to grid, format the numbers to not include decimals and then switch visualization back to chart. The decimals are still there. Any other setting that needs to be changed to remove the decimals in the chart?
Found the answer to my own question above, so if anyone else is struggling with the same issue, the trick is to click “Select all cells” when formatting the grid, then it also fixes the chart view.
Hi
Here is the behavior I have.
Please let me know if this helps or if you’re facing a different behavior?
Thanks,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.