How To Create a Graph from an Excel Spreadsheet

The Microsoft Excel spreadsheet is one productivity tool that surely has a lot of features. Aside from it being able to compute for values that you have entered, it can render the collected data into a graph for purposes of visual presentation.

  1. Access a new Microsoft Excel spreadsheet. Click on the Start button for a pull up menu window to appear. Direct your mouse pointer to All Programs, and you will see another cascading menu will appear. Locate Microsoft Excel and click on it once for a new spreadsheet to be opened.
  2. Enter your collected data into the rows and columns of Microsoft Excel. Microsoft Excel has columns marked by letters A through Z. Meanwhile, its rows are labeled with numbers. The first thing that you would need to input would be the title. Direct your mouse pointer to the cell right below Column A and right beside Row 1, the A1 cell. You will need to type in your choice of title into cell A1. Do the same process for placing in the intended title for cell B1. After you are done putting in the titles, then the next step that you would need to do is to type in all of your collected data into their respective cells.
  3. Have Microsoft Excel render the data into a graph. Highlight all of the cells containing the data you wish to include in your graph. To do this, drag the mouse to the respective cells to highlight them. Once done, proceed to creating the graph. To do this, go to the toolbar at the topmost section of the Microsoft Excel window. Select the fourth option, the Insert tab, by clicking on it once. A dropdown list appears, after which you will need to select the option Chart. The Chart Wizard dialog box then appears. Choose from among the many supplied sample charts in the Standard Types and Custom Types tabs. If you want to preview the image of your choice of chart complete with your own collected data, click on the button that's labeled Press and Hold to View Sample.
  4. Do some more tweaking of your graph settings. Click on Next to go to Step 2 of the Chart Wizard. In here, you can set the Data Range and Series of your Excel graph. Click on Next once more to proceed to Chart Wizard step 3. Setting additional titles for the various axes of your graph can be done in here. Click on Next again to go to the final step, which is determining whether you want the chart placed as a new Excel spreadsheet or just one of the sheets to be contained in the file.

Once these settings are ascertained, then click on the button Finish and you will see your data rendered in your graph of choice. If you have chosen the option of creating a new sheet, then you will need to save this spreadsheet to finally finish off. Click on the first tab File and then Save. Key in the file name of choice and have the new Excel spreadsheet saved in your choice of save location.


Share this article!

Follow us!

Find more helpful articles: