Thread: 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

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

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
>

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