#1   Report Post  
Posted to microsoft.public.excel.charting
matt
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 scale in a single chart dom Charts and Charting in Excel 1 March 4th 06 02:48 PM
Changing the scale major unit in a graph Ant Excel Discussion (Misc queries) 2 February 6th 06 01:42 PM
Chaning X axis scale in Excel 2003 wendythelwell Charts and Charting in Excel 2 August 9th 05 02:35 PM
Chart scale & paper size F3 New Users to Excel 0 May 27th 05 10:01 PM
Excel Charts - Data being Plotted beyond Primary X-Axis Scale Yvonne Fochesato Charts and Charting in Excel 1 May 1st 05 03:36 AM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"