Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
log scale
I would like to have the horizontal axis displayed in a log scale. This
option ios not showing up in the format axisa dialog box. It does showw up in the vertical axis. This is a standard line chart. I have excell 2000 There are no negative numbers in the horizontal axis. Any idea why the log scale option is not showing up. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
log scale
Matt:
It sounds like you are using a line chart. Excel line charts use categorical values for X axis, not numeric values. Even though your data looks like numbers, the line chart treats them as text. Change your chart type to an XY (Scatter) chart, then the log scale will be available on X axis. Right click chart, select chart type, the XY (Scatter). ....Kelly "matt" wrote in message ... I would like to have the horizontal axis displayed in a log scale. This option ios not showing up in the format axisa dialog box. It does showw up in the vertical axis. This is a standard line chart. I have excell 2000 There are no negative numbers in the horizontal axis. Any idea why the log scale option is not showing up. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 scale in a single chart | Charts and Charting in Excel | |||
Changing the scale major unit in a graph | Excel Discussion (Misc queries) | |||
Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
Chart scale & paper size | New Users to Excel | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel |