I want to plot a semi log plot in excel along with grid lines. Can anyone tell how to do?
O Omkar Apr 9, 2006 #1 I want to plot a semi log plot in excel along with grid lines. Can anyone tell how to do?
T Tushar Mehta Apr 9, 2006 #2 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
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
O Omkar Apr 10, 2006 #3 Omkar said: I want to plot a semi log plot in excel along with grid lines. Can anyone tell how to do? Click to expand... 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.
Omkar said: I want to plot a semi log plot in excel along with grid lines. Can anyone tell how to do? Click to expand... 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.
M Mike Middleton Apr 10, 2006 #4 Omkar - ... But the how to plot Log-Log graph? ... < Click to expand... Use an XY (Scatter) chart type. - Mike www.mikemiddleton.com
Omkar - ... But the how to plot Log-Log graph? ... < Click to expand... Use an XY (Scatter) chart type. - Mike www.mikemiddleton.com
O Omkar Apr 10, 2006 #5 Mike Middleton said: Omkar - Use an XY (Scatter) chart type. - Mike www.mikemiddleton.com Thak you very much Prof. Click to expand...
Mike Middleton said: Omkar - Use an XY (Scatter) chart type. - Mike www.mikemiddleton.com Thak you very much Prof. Click to expand...
