• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Log Scale

RobSA

RobSA

Member
Hi folks, I use Excel 2007 and am trying to set up a log scale. ANy help or working example would be most appreciated ?


Regards

Rob
 
Rob


Firstly welcome to the Chandoo.org Forums


When you say setting up a log scale?


If it is on a Chart,

Right Click the Axis

Format Axis

Tick the Logarithmic Scale Check Box

Change the Log Base if required, it Defaults to 10


If that isn't what you mean please elaborate?
 
Hi,


I have managed to do the graph but when I change it to log scale the lines do not represent correcly.


It stays ok fro one line but the remaining two then present in a different manner - when using scatter plot.


Thanks for your response.


Regards

Rob
 
Do you want to post your file

With a description of the problem ?
 
Hi Luke,


Thanks for the help.


The file can be veiwed at this link https://spreadsheets.google.com/spreadsheet/ccc?key=0Ahe_P6TwosJTdENQNElJNWJ2aGFBR2plY1hoU1U3X1E&hl=en_US&authkey=CJPftrYG


Regards

Rob
 
Rob


I couldn't work out which series were being charted but made a guess anyway


I have made as sample using your data at

https://rapidshare.com/files/2920236361/BEDDING_SAND__Hui_.xlsx


It is a X-Y or Scatter chart

As you found out the Area Charts don't allow Log X Axis


I have added some intermediate series which you can adjust to suit your data
 
You must log in or register to reply here.
Back
Top