How to plot semi log graph in Excel?

[Guest]

I want to plot a semi log plot in excel along with grid lines. Can anyone
tell how to do?

 

[Tushar Mehta]

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/newsgroups/flexible_log_scale/index.html

--
Regards,

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

 

[Guest]

I want to plot a semi log plot in excel along with grid lines. Can anyone
tell how to do?

Thanks for your help. But the how to plot Log-Log graph? There is no
'logaritjhmic scale' option on x axis.
Sorry for bothering again.

 

[Mike Middleton]

Omkar -

... But the how to plot Log-Log graph? ... <

Use an XY (Scatter) chart type.

- Mike
www.mikemiddleton.com

 

[Guest]

Omkar -


Use an XY (Scatter) chart type.

- Mike
www.mikemiddleton.com

Thak you very much Prof.