Trnasform Axes of Excel Chart

[JackCane]

Is there a way to transform axis in Excel chart, say fm x to 1/x, or from y
to log y.

Idea is, to continue plotting x and y, but to DISPLAY periodic axis labels
and tics at the transformed values,.

 

[Bernard Liengme]

Make a column of log(y) values
Add this to your chart (using Paste Special, perhaps)
Put the log(y) data series on a secondary axis
adjust its scale
Now format the log(y) data series to be invisible (maybe no lines, and no
makers)
best wishes