Trnasform Axes of Excel Chart

  • Thread starter Thread starter JackCane
  • Start date Start date
J

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