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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone notification 0
Filtered view of Visio Chart 0
Custom Format numbers for learning chart 0
Problem with Excel 2007 clustered column chart on log scale 1
Log scale and minor gridline labels 2
Changing login email address for office 365 admin (O365 Busines) 0
evenly spaced markers on log scale 1
How to create a bubble chart with more than 2 variables. 0

Top