Chart Horizontal Axis

Karen Passmore

My data values range from 0-50 however when adding a chart the horizontal axis reads like this... 0, .50, 1, 1.50, 2, 2.50, etc.  How can I change it so the axis is whole numbers solely.  My data is whole numbers and therefore I would think it should reflect same.

 

Paul Newcome

Unfortunately there is no way to specify a change to the scale, but it would be nice. Feel free to submit a product enhancement request.

 

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.17066618.256192998.1563365586-754325437.1561562560

Karen Passmore

I have resolved this issue. The scale adjusts based on the size of the chart, if you make the chart larger it will expand the scale (e.g. 1, 1.5, 2, 2.5) but if you decrease the scale reverts back to 1, 2, 3. 

Paul Newcome

Yes. I completely forgot about that. The scale will adjust to the size of the chart and the data itself. It would still be nice to specify the scale though regardless of data or size.

Andrée Starå

Hi,

Excellent!

Thanks for sharing!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting