ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to plot semi log graph in Excel? (https://www.excelbanter.com/charts-charting-excel/82335-how-plot-semi-log-graph-excel.html)

Omkar

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

Tushar Mehta

How to plot semi log graph in Excel?
 
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 ,
says...
I want to plot a semi log plot in excel along with grid lines. Can anyone
tell how to do?


Omkar

How to plot semi log graph in Excel?
 


"Omkar" wrote:

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

How to plot semi log graph in Excel?
 
Omkar -

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


Use an XY (Scatter) chart type.

- Mike
www.mikemiddleton.com



Omkar

How to plot semi log graph in Excel?
 


"Mike Middleton" wrote:

Omkar -

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


Use an XY (Scatter) chart type.

- Mike
www.mikemiddleton.com

Thak you very much Prof.



All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com