Line Chart Y Axis Invert (New Or Old Version Accepted)

[TennysonK]

Is there a way to Invert the Y Axis order? Ex. 10,9,8...etc instead of 1,2,3... I know that I could preface the real value with it's inverse OR with A-Z, however this is messy and confusing/complicating the chart.

Example table for what the chart would look like.

1	X
2			X
3		X
4				X
	2018	2019	2020	2021

Apologies if the table is confusing, I don't have time to make a proper example.

[gregdiana1]

Yes this is easily and readily done with the old chart as shown below

As is seen the old chart has a Sort by option and if one sorts timestamp by Descending it will reverse the order as shown below

Hope this helps.

[TennysonK]

Hi Gregdiana1, that is only altering the X-axis order, not the Y-axis.

[gregdiana1]

It appears you want to reverse the Y-axis scale and not the Y-axis order. If the y-axis scale is 0-100 then do you want the scale to be 100-0.

So it is not clear what you require?

[TennysonK]

Yes, apologies for not being completely clear earlier/using wrong terminology. I wish to reverse the Y-axis scale.

[gregdiana1]

I am aware that the chart application that  APPSHEET uses allows this but APPSHEET itself does not provide the functionality to do so.

You can do this in excel as shown below by changing the Y-axis min max values

As you see it treats them as negative numbers and will work if you make the numbers negative

I did the same with APSHEET using -ve numbers and this is what I got