Creating Charts and Graphs in Excel

Here are some basic steps for creating charts and graphs in Excel 2007 and 2003 and pasting them into Word. Microsoft makes some online training for charts.

Pie Charts

Don't forget: Microsoft offers some tutorials on charts.

In Excel 2003 and 2007:

  1. Move to several rows below the top row and several columns away from the first column.
  2. In your first column, enter the labels (for example, Canada, USA, Mexico). (Optionally, enter the data in parentheses just after these labels.)
  3. In your second column, enter the numbers associated with these labels (for example, population of each).
  4. Highlight these labels and data.



  5. Click Insert > Pie Chart, and select the simplest type of pie chart. When click the chart type, Excel creates the chart.

  6. Copy the chart, in your word-processing document add some lines above and below where you want the chart, and then paste the chart.
  7. If you want to get rid of border lines around the chart, highlight the chart and search for a format option. In Word 2007, with the chart highlighted, right-click, select Format Chart Area, and then select Border Color > No line.
  8. Your word-processing application may enable you to add a caption (chart title). In Word 2007, with the chart highlighted, right-click and select Insert Caption.

Note: The steps in Excel 2003 are very similar. Excel 2003 gives you some options, but you can just take the defaults.

Column and Bar Charts

In Excel 2003 and 2007:

  1. Move to several rows below the top row and several columns away from the first column.
  2. In your first column, enter the labels (for example, Canada, USA, Mexico). (Optionally, enter the data in parentheses just after these labels.)
  3. In your second column, enter the numbers associated with these labels (for example, population of each).
  4. Highlight these labels and data.
  5. Click Insert > Column, and select the simplest type of column chart. When click the chart type, Excel creates the chart.


  6. Copy the chart, add some lines above and below where you want the chart in your word-processing document, and then paste the chart. (I don't know why the Series 1 thing is inserted; just delete it.)
  7. If you want to get rid of border lines around the chart, highlight the chart and search for a format option. In Word 2007, with the chart highlighted, right-click, select Format Chart Area, and then select Border Color > No line.
  8. Your word-processing application may enable you to add a caption (chart title). In Word 2007, with the chart highlighted, right-click and select Insert Caption.

Note: The steps in Excel 2003 are very similar. Excel 2003 gives you some options, but you can just take the defaults.

Line Graphs

A tutorial on line charts is available at About.com. This tutorial points out that Microsoft has changed the name from "line graphs" to "line charts."

In Excel 2003 and 2007:

  1. Move to several rows below the top row and several columns away from the first column.
  2. In your first column, enter the labels (for example, January, April, August).
  3. At the top of the next two columns, enter the column headings (for example, Minneapolis, Atlanta, Austin).
  4. Below those column headings, enter the numbers associated with the column headings (for example, average January, April, August temperatures).
  5. Highlight these labels and data.

  6. In Excel 2007, click Insert > Line, and select the simplest type of line graph (chart).

    When you click the Line, Excel creates the line graph. (In Excel 2003, click Insert > Chart > Line.)
  7. Copy the chart, add some lines above and below where you want the chart in your word-processing document, and then paste the chart.
  8. If you want to get rid of border lines around the chart, highlight the chart and search for a format option. In Word 2007, with the chart highlighted, right-click, select Format Chart Area, and then select Border Color > No line.
  9. Your word-processing application may enable you to add a caption (chart title). In Word 2007, with the chart highlighted, right-click and select Insert Caption.

Note: The steps in Excel 2003 are very similar. Excel 2003 gives you some options, but you can just take the defaults.

Some additional resources:

How to create a chart in Excel 2007. Provided by Microsoft.
How to Create a Line Graph in Excel 2007. Provided by eHow.
How to Make a Pie Chart in Microsoft Word. Provided by eHow.
How to Make a Pie Chart With Microsoft Excel. Provided by eHow.
How to Make a Circle Graph With Excel. Provided by eHow.

Programs and information provided by hcexres@prismnet.com.