Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

log log graphs

Status
Not open for further replies.

athomas236

Mechanical
Jul 1, 2002
607
Is ther any way to plot log log graphs in Excel and have the axes shown as the correct numbers

athomas236
 
Replies continue below

Recommended for you

Plot it as an "X-Y (Scatter)". Format each axis to log scale (Scale -> Logarithmic scale).....
 
Just guessing - the original poster might want the limits of the axis to be the actual data limits, not the nearest power of 10. In which case, I think, the answer is no.

Cheers

Greg Locock
 
Thanks for your help but Greg is correct I want the axes to show the original data values.

athomas236
 
You can probably do this if you are prepared to write some Visual Basic... but it sounds like a fair amount of work.

If you just want to do it for your own satisfaction and can live with logs as the axes then just plot the log of each series as a normal x-y plot, then you can rescale to your heart's content.



Cheers

Greg Locock
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor