Revered members,
I just now bought MsOffice 2010. I need to draw a graph similar to my attachment in Excel 2010. I dont know how to do this in Excel. I used the help option in office but i can't understand. Please guide me how to draw. As i am a physics student line graph is essential to me.

 

First of all ! make sure that there is some data in your excel sheet and that your excel sheet does not contain any blank cells between the different columns, then click the Insert 'menu' and choose the chart type that you wish to draw.

Once the chart is drawn, it becomes very easy to change the attributes, right-click the chart and you will see the options for changing chart types, data, and other formatting.

That's it, Hope this helps

 

Thanks for the reply. I have attached the screen shots the the graph i got. I didn't get what i wanted as mentioned in OP

 

Use scatter graph rather than line graph.

 

In much less time that it takes to post here you could try ALL the graphic options you have. Is that simple.

 

the graph you got drew two lines using row numbers for x-axis and column A and B data for y axis producing two graphs. If you want to use column A for x and column B for y axis data, select scatter graph, if you right click on the actual series label, you should be able to select data - as in select data you want for x-axis and y-axis. You can use select data function to edit line graph as well. If you need to have a line drawn though the scatter plot, right click on the points on the graph and go to "add trendline", you want linear.

hope this helps

 

the graph you got drew two lines using row numbers for x-axis and column A and B data for y axis producing two graphs. If you want to use column A for x and column B for y axis data, select scatter graph, if you right click on the actual series label, you should be able to select data - as in select data you want for x-axis and y-axis. You can use select data function to edit line graph as well. If you need to have a line drawn though the scatter plot, right click on the points on the graph and go to "add trendline", you want linear.

hope this helps

The trendline function in excel is nearly useless! the LINEST function is far more versatile, and allows you to use the generated coefficients for other calculations in the spreadsheet. just my 2 cents...

 

The trendline function in excel is nearly useless! the LINEST function is far more versatile, and allows you to use the generated coefficients for other calculations in the spreadsheet. just my 2 cents...

Agree, it's useless if your data is non-linear, which is not the case here. I had a horrible time learning excel because there is no support, and still dislike using it If you are going to point to advanced features like LINEST, maybe give a hint on how to use them?

http://www.excelfunctions.net/Excel-Linest-Function.html

 

Agree, it's useless if your data is non-linear, which is not the case here.

No, the trendline option does allow for some limited non-linear curve fits. The problem is that your analysis ends there. There is no method to capture the generated coefficients into your worksheet (without manually transcribing the data). Usually, a curve fit is just the beginning of my analysis...not the end!

If you are going to point to advanced features like LINEST, maybe give a hint on how to use them?

Nah. I figure if someone is too lazy to Google, they're not worth the effort. I *like* leaving snippets of incomplete info that may send someone off onto some new random direction!

BTW, I don't use excel. I prefer LibreOffice.

 

Linest can be used for higher order polynomials within the excel spreadsheet. It's just a pain in the ass as you need to create new data columns with the x^2, x^3 values etc.

 

Nah. I figure if someone is too lazy to Google, they're not worth the effort. I *like* leaving snippets of incomplete info that may send someone off onto some new random direction!

BTW, I don't use excel. I prefer LibreOffice.

Sure, all in good fun if you know what you are looking for, otherwise hours of wasted time trying to find a link that provides you with valuable information. Sometimes it is good to just point to the source just my 2 cents.

 

Sure, all in good fun if you know what you are looking for, otherwise hours of wasted time trying to find a link that provides you with valuable information. Sometimes it is good to just point to the source just my 2 cents.

Funny, when I spend hours on research (which I do nearly every single day), I never consider the time wasted. I very rarely walk away without having learned *something* valuable. Even if it wasn't what I was originally looking for!

 

while I don't consider googling about excel research, I have to thank you for telling me about LibreOffice, didn't know about it.

 

...thank you for telling me about LibreOffice, didn't know about it.

Hah! And I didn't even provide a link!

 

I use MATLAB for drawing graphs. The data analysis and graph drawing capabilities are much superior than Excel.

 

the graph you got drew two lines using row numbers for x-axis and column A and B data for y axis producing two graphs. If you want to use column A for x and column B for y axis data, select scatter graph, if you right click on the actual series label, you should be able to select data - as in select data you want for x-axis and y-axis. You can use select data function to edit line graph as well. If you need to have a line drawn though the scatter plot, right click on the points on the graph and go to "add trendline", you want linear.

hope this helps

Thanks a lot justtrying. Now i want to add the label Voltage for X axis and Current for Y axis. How to do it?

 

to add labels, check out all the options under "chart tools" - you are looking for "axis titles"

 

i could not find chart tools in the menu bar. How to go that option?

 

the chart menu bar comes up above the tool bar when you click on the chart that you have created.

 

Thanks a lot justtrying. You made my day. Now i could draw graphs as i wanted. Thanks a lot.