log log charts in excel

D

Dave P

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

Thanks
 
D

Dave P

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

Thanks
Dave P
 
D

David Biddulph

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.
 
M

MartinW

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
 
Top