how do i change the x-axis of a graph to a log scale?

i've got some data that i want to display on a semi log graph, but i want to
change the x-axis to a log scale, not the y-axis. How do i do this?
anne

Anne:

Double click any value on your x axis, this will bring up Axis format form.

Select scale tab, check Logarithmic checkbox. Make sure that your minimum
value is 1, 10, 100, and your major & minor units must be multiples of 10.

...Kelly

koday@processtrends.com





"anne" <anne@discussions.microsoft.com> wrote in message
news:285AD745-5EA2-4C2F-8A39-2E4CBD61C3BD@microsoft.com...
> i've got some data that i want to display on a semi log graph, but i want
> to
> change the x-axis to a log scale, not the y-axis. How do i do this?
> anne

That's great, thanks
anne

"Kelly O'Day" wrote:

> Anne:
>
> Double click any value on your x axis, this will bring up Axis format form.
>
> Select scale tab, check Logarithmic checkbox. Make sure that your minimum
> value is 1, 10, 100, and your major & minor units must be multiples of 10.
>
> ...Kelly
>
> koday@processtrends.com
>
>
>
>
>
> "anne" <anne@discussions.microsoft.com> wrote in message
> news:285AD745-5EA2-4C2F-8A39-2E4CBD61C3BD@microsoft.com...
> > i've got some data that i want to display on a semi log graph, but i want
> > to
> > change the x-axis to a log scale, not the y-axis. How do i do this?
> > anne
>
>
>

Make sure you create (or change to) a XY Scatter chart. Now, double-click
the x-axis and in the resulting dialog box, select the Scale tab. The last
step should be self-evident. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <285AD745-5EA2-4C2F-8A39-2E4CBD61C3BD@microsoft.com>,
anne@discussions.microsoft.com says...
> i've got some data that i want to display on a semi log graph, but i want to
> change the x-axis to a log scale, not the y-axis. How do i do this?
> anne
>