how can I make a chart with the x-axis in logarithmic scale

how can I make a chart with the x-axis in logarithmic scale. the built in
function makes the y-axis log

Hi,

You need to use the xy scatter chart type if you want an x-axis log scale.

Cheers
Andy

Doris wrote:
> how can I make a chart with the x-axis in logarithmic scale. the built in
> function makes the y-axis log

--

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

Where do I set log scale for x-axis on scatter plot

"Andy Pope" wrote:

> Hi,
>
> You need to use the xy scatter chart type if you want an x-axis log scale.
>
> Cheers
> Andy
>
> Doris wrote:
> > how can I make a chart with the x-axis in logarithmic scale. the built in
> > function makes the y-axis log
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Double click the x axis. This should display the format dialog.
On the Scale tab is the option for Log scale (very similar to y axis
method).

Cheers
Andy

Doris wrote:
> Where do I set log scale for x-axis on scatter plot
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>You need to use the xy scatter chart type if you want an x-axis log scale.
>>
>>Cheers
>>Andy
>>
>>Doris wrote:
>>
>>>how can I make a chart with the x-axis in logarithmic scale. the built in
>>>function makes the y-axis log
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

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

Never mind, I found it. Thanks so much
doris

"Andy Pope" wrote:

> Hi,
>
> You need to use the xy scatter chart type if you want an x-axis log scale.
>
> Cheers
> Andy
>
> Doris wrote:
> > how can I make a chart with the x-axis in logarithmic scale. the built in
> > function makes the y-axis log
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>