Double click the y-axis, then from the Scale tab select 'Logarithmic scale'
To create custom "gridlines" see
Flexible Log Scale
http://www.tushar-mehta.com/excel/ne...ale/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <A1C5FF9E-A1C2-4254-B547-E0B60EFC34FD@microsoft.com>,
Omkar@discussions.microsoft.com says...
> I want to plot a semi log plot in excel along with grid lines. Can anyone
> tell how to do?
>