Learn How To Plot A Graph In Excel Using Simple Steps

Asked By 5 points N/A Posted on -
qa-featured

Hi. I have recently started using MS-Excel. I need to prepare a graph in Excel. How to plot a graph in Excel? Please reply ASAP. Thanks in advance.

SHARE
Answered By 210 points N/A #86377

Learn How To Plot A Graph In Excel Using Simple Steps

qa-featured

Hi. To learn how to plot a graph in Excel, first click on Start and then on the icon of MS-Excel to launch it. Open a new spread sheet with the data which needs to be converted into a X-Y plot. Select the columns or rows which should be included along with the data in the plot. Then, click on insert and select the scatter menu. Select the scatter plot options from among scatter with only markers, smooth lines and markers with straight lines. The scatterplot selected will be inserted into the spread sheet. Then, select the chart tools from the work area which appears only after the chart has been enabled. You can also change how the scatterplot appears from the chart styles menu by changing the colour, line, width and the shading. However, this customization is totally optional and up to you.

Hope we helped.

Login/Register to Answer

Related Questions