Hello, I'm making a study about a river's water level and I need to invert the values of the Y axis. It's very easy to do it with Microsoft Office Exel but I don't know how to do it with Number.
I have Numbers 3.6.1
Hi J',
I'm having some difficulty visualizing the data and the chart it is to create. In my mind, the data points should rise on the chart to indicate a rise in the level of the river surface level (or of the flow volume).
Perhaps a sample of the data would make the request more clear.
Regards,
Barry
I suggest creating a chart and hiding the actual Y axis values and make your own axis labels with a separate table (it's a work around since Numbers does not do what you want natively).
I searched for example of river level charts and could not find any examples, so, I, too, am not sure what you want to show. IF you have an example, that would be very helpful to see.
I searched and found quite a few images of depths where the y-axis is reversed. In Excel reversing takes a click of a checkbox, like this:
I think in Numbers you would have to add a column in the data that reverses the sign of the depth values, and chart that.
Then cover the axes in the chart with text boxes with a solid fill.
SG
How can I invert the Y axis to have the lowest number at the top?
