Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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,. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Bar and Line chart on 2 Axes | Charts and Charting in Excel | |||
Excel Chart question using two y axes | Excel Discussion (Misc queries) | |||
How to create a line chart with two X-axes in Excel | Excel Discussion (Misc queries) | |||
How do I scale excel chart axes from vb? | Charts and Charting in Excel | |||
Can I create an Excel chart with two x-axes? | Charts and Charting in Excel |