#1   Report Post  
Peter Svendsen
 
Posts: n/a
Default Logarithmic axis

Hi, I have an urgent question

I need to be able to change my chart axis when they are logarithmic. As
standard you can only decide 1,10,100 etc... I need for an example to change
them from 1 to 500!!!

Hope that someone can help me with a name on an ADDINN som a solution in
some way
--
Peter Svendsen
Danish Technological Institute
Engineer
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Check out Tushar's flexible log example.
http://tushar-mehta.com/excel/newsgr...ale/index.html

Cheers
Andy

Peter Svendsen wrote:
Hi, I have an urgent question

I need to be able to change my chart axis when they are logarithmic. As
standard you can only decide 1,10,100 etc... I need for an example to change
them from 1 to 500!!!

Hope that someone can help me with a name on an ADDINN som a solution in
some way


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Peter Svendsen
 
Posts: n/a
Default

Hey

I should be able to use it... This is only with the y axis logarithmic....
If we have both y and x axis logarithmic it is the same procedure right?

Thanks for the quick answer

"Andy Pope" skrev:

Hi,

Check out Tushar's flexible log example.
http://tushar-mehta.com/excel/newsgr...ale/index.html

Cheers
Andy

Peter Svendsen wrote:
Hi, I have an urgent question

I need to be able to change my chart axis when they are logarithmic. As
standard you can only decide 1,10,100 etc... I need for an example to change
them from 1 to 500!!!

Hope that someone can help me with a name on an ADDINN som a solution in
some way


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #4   Report Post  
Andy Pope
 
Posts: n/a
Default

Yes, just make sure you use a xy scatter and not a line chart.

Peter Svendsen wrote:
Hey

I should be able to use it... This is only with the y axis logarithmic....
If we have both y and x axis logarithmic it is the same procedure right?

Thanks for the quick answer

"Andy Pope" skrev:


Hi,

Check out Tushar's flexible log example.
http://tushar-mehta.com/excel/newsgr...ale/index.html

Cheers
Andy

Peter Svendsen wrote:

Hi, I have an urgent question

I need to be able to change my chart axis when they are logarithmic. As
standard you can only decide 1,10,100 etc... I need for an example to change
them from 1 to 500!!!

Hope that someone can help me with a name on an ADDINN som a solution in
some way


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


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