how to change chart widget axis scales

Victor Wang · 07/23/20

Hi,

I am just wondering if the axis scales values can be changed to fixed values instead of dynamics as it is right now.

I would like the vertical axis range values to be set to 0-100% for my below graph:

Thanks.

Victor

Paul Newcome · 07/24/20

Happy to help. 👍️

Paul Newcome · 07/23/20

The only way to get the axis data to change is to either change the size of the widget and/or change the source data.

Victor Wang · 07/23/20

thanks, Paul.

Paul Newcome · 07/24/20

Happy to help. 👍️

James Brown · 12/16/20

Have a column in your counts sheet that says 100%.

Add that column to your chart as a reference, then in the Series bit in the edit, change its colour to white (or whatever your background colour is)

Best Answer