Trnasform Axes of Excel Chart
 

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,.

Trnasform Axes of Excel Chart
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"JackCane" wrote in message
...
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,.