Thursday, July 30, 2009

How can i plot a Graph on Microsoft Excel?

Hey Friends, ireally need your help on this.


I need to plot a curve for the given graph.


I have the points,so can you please give detailed step by step instructions for making the graph on Microsoft Excel of Course.


This is a bit urgent.

How can i plot a Graph on Microsoft Excel?
1. In an empty worksheet enter the data for the x (horizontal) axis in a column and then enter the y (vertical) axis values in the corresponding rows of the next column to the right.


2. Select any cell you have entered the data in and then select Insert %26gt; Chart.


3. Select XY(Scatter) %26gt; Next (or Finish)


4. Check that the graph include the data you entered and select Next (or Finish)


5. Enter Chart title, a name for the x axis values, and a name for the y axis values and select Next (or Finish)


6. Select whether you want the chart on the sheet with the data or on its own separate new sheet and select Finish.


7. If you are not happy with the results you can immediately delete it with the delete key and start over or you can select Chart (it is visible at the top only when the chart is selected) and any of the options under it to experiment with making changes. You will probably want to add a trend line.





If you select Finish in steps three, four, or five above, the chart wizard will complete the chart using guesses. Adding extra trend line can be interesting; but be careful, the can be hard to delete. And remember the undo arrow (or ctl-z keys) to reverse a major mistake like deleting the entire graph. And saving the first acceptable graph you get is always wise.


No comments:

Post a Comment