Dashboard Chart Widget Vertical Axis Numbering

Shesha_K

So, I have added a few new charts to an old dashboard, and for some reason the new charts are adding a decimal and two zeros to my vertical axis numbers.  It isn't the end of the world if the numbers look like this: 5.00, 10.00, etc. But, I would prefer that they simply be whole numbers. In previous charts I have created they show as whole numbers no decimals. I am sure it is something simple, but I have been looking for an answer and can't seem to find it. Does anyone know offhand how to correct this? I have attached an image the top chart is one of the new ones with the undesired decimals, and the bottom is an older chart with the more concise whole numbers. All of the data sets are whole numbers in case that is thought to be an issue. I appreciate your help with this!

Paul Newcome

Check the number formatting on the source sheet. That's the only way I was bale to replicate it was by adding decimals there.

Ellen Rinker

I am having the same issue. I have two bar chart widgets that come from the same column, different rows. One chart has decimals, the other has whole numbers?

Data Source.pdf

Paul Newcome

@Ellen Rinker It looks like it may have to do with the size of the widget in relation to the values of the actual data. Try adjusting the size of the widget and see if that helps. If it does not... How are you populating the data for the widgets?

Yulichka

It is indeed due to the size of the widget in relation to the values of the actual data. I adjusted the size (i.e. made the chart wider) and the diagonal Horizontal Values straightened out completely. Thank you very much, Paul!