log log charts in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave P - 31 Aug 2008 07:44 GMT

Can somebody please advise me how I may chart data using log scales on either
or both axes?

Thanks

Reply to this Message

David Biddulph - 31 Aug 2008 09:42 GMT

Format Axis/ Scale tab

Signature

David Biddulph

> Can somebody please advise me how I may chart data using log scales on
> either
> or both axes?
>
> Thanks

Reply to this Message

Dave P - 31 Aug 2008 13:27 GMT

Hi Thanks for the response, however this only allows it on the vertical
axis....
what about the horizontal axis?

Thanks
Dave P

> Format Axis/ Scale tab
> > Can somebody please advise me how I may chart data using log scales on
> > either
> > or both axes?
> >
> > Thanks

Reply to this Message

David Biddulph - 31 Aug 2008 13:34 GMT

Same.

If you don't have that option available, it's probably because you've got
the wrong Chart Type. If you are using a Line Chart, change it to XY (which
can still do lines, with our without marker points).
The Chart Types are very misleadingly named. Many people end up choosing a
line chart when what they need is XY.
--
David Biddulph

> Hi Thanks for the response, however this only allows it on the vertical
> axis....
[quoted text clipped - 9 lines]
>> >
>> > Thanks

Reply to this Message

MartinW - 31 Aug 2008 13:36 GMT

Hi Dave,

Sounds like you are using a line chart.
Change it to an XYscatter and you can apply
log scale to either axes.

HTH
Martin

> Hi Thanks for the response, however this only allows it on the vertical
> axis....
[quoted text clipped - 9 lines]
>> >
>> > Thanks

Reply to this Message