Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski 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
Joined
Jul 1, 2002
Messages
607
Location
GB
Is ther any way to plot log log graphs in Excel and have the axes shown as the correct numbers

athomas236
 
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

Back
Top