Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default logarithmic x-axis with a maximum between 100 and 1000

I have office 2000, Excel. I would like to do a diagram with a logarithmic
x-axis with a maximum between 100 and 1000. Is that possible or do I have to
select an axis maximum that are 10x?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default logarithmic x-axis with a maximum between 100 and 1000

Noss,

AFAIK, you are limited to complete decades when using the logarithmic scale on the Y axis.

HTH,
Bernie
MS Excel MVP


"NossAB" wrote in message
...
I have office 2000, Excel. I would like to do a diagram with a logarithmic
x-axis with a maximum between 100 and 1000. Is that possible or do I have to
select an axis maximum that are 10x?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default logarithmic x-axis with a maximum between 100 and 1000

Hi,

If you use a xy-scatter chart you can enable the log x-axis.

Have a look at Tushar Mehta's flexible log scale for information on
setting non 10x axis values.
http://tushar-mehta.com/excel/newsgr...ale/index.html

Cheers
Andy

NossAB wrote:
I have office 2000, Excel. I would like to do a diagram with a logarithmic
x-axis with a maximum between 100 and 1000. Is that possible or do I have to
select an axis maximum that are 10x?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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



All times are GMT +1. The time now is 12:29 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"