semi log and log log plot in excel

Follow instructions here for formatting the value (Y) axis to enter the appropriate dialog. Check the "logarithmic axis" option (with desired logarithm base). this will create a semi-log plot. Since the X axis is also a value axis, repeat the same procedure for the x axis when creating a log-log plot.
http://office.microsoft.com/en-us/ex...163.aspx?CTT=1

Originally Posted by selvaveera

Thank you. i am having a voltage decay date which have positive and negative values i want to make a logarithmic y axis with normal values in the x axis for semi log plot also want to make a log log in both axis for log log plot. there is no attachment option here. how to attach my excel sheet.

To use attachments, you have to go advanced when you reply to a post and use the paperclip icon.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic