Graph Inverse

I have an array of numbers which can be plotted on a graph.

All x values should be kept the same.

All y value should be invesed so that the lowest y value become the highest y value and visa versa.

Any thoughts on how to do this?

Thanks in advance

Quote:

---

Originally Posted by calypso

I have an array of numbers which can be plotted on a graph.

All x values should be kept the same.

All y value should be invesed so that the lowest y value become the highest y value and visa versa.

Any thoughts on how to do this?

Thanks in advance

---

I hope you are allowed to use Excel or any other spreadsheet.

I've attached a screen-shot of the operations. Read from left to right.