How to plot semilog graph with data?

**mdshihabh** · 07-21-2012, 10:56 AM

Hello Everybody,

This is my first post in this forum. i am newbie to excel. I have a semi-log graph data first column X axis data and the second column is its corresponding Y data.
The data sheet is given here .

Now i want to plot a semi-log graph using these data. But i cant do it due to lack of my knowledge in excel. I have googled for this problem but failed to do it. I need help...I will be grateful to this forum for that.

The data is obtained from this graph.sample2.jpg

I want the same graph using Excel 2007. What steps should i follow? Anyone have the time to explain in details........

**MrShorty** · 07-21-2012, 10:58 AM

I can't download your file at present, but it seems like it should be as simple as creating an XY scatter plot with the data, then formatting the y axis so it is a logarithmic scale.

Is that what you need, or is there more to the question that I'm not seeing?

**jpr73** · 07-21-2012, 04:40 PM

Hi,
See attached file of the semilog graph
As MrShorty said insert an XY Scatter plot and format Y axis with a logarithmic scale
Hope this help
Best regards