how to change chart widget axis scales

Victor Wang

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:

Screen Shot 2020-07-23 at 10.41.10 am.png

Thanks.

Victor

Paul Newcome

Happy to help. 👍️

Paul Newcome

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

thanks, Paul.

Paul Newcome

Happy to help. 👍️

James Brown

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)