Lesson 22: Creating Graphs from Excel Data

     Creating a graph from Excel data is easy. Graphs created using Excel look great and are very functional. Excel allows you to place your raw data and your chart on the same page. Before printing the sheet, make sure you do a print preview first. The print preview gives you an idea about how much space is used on the sheet and you can manipulate the size of the graph using the graph's sizing handles to maximize the amount of space used on the sheet.

To create a graph in Excel, do the following:

  1. Enter your data
  2. Highlight the entire table.
  3. Click the chart wizard button.
  4. Select the scatter plot and click next.
  5. Click next.
  6. Label the chart title, x-axis and y-axis. Click next.
  7. Click finish.
  8. Resize your graph using the sizing handles
  9. Click on the print preview button to see how your new graph fits on the page. Adjust the size accordingly using the sizing handles.