If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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,. |
#2
|
|||
|
|||
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,. |
Thread Tools | |
Display Modes | |
|
|