Tutorial Line Chart in Excel 2003

Contents
  1. Overview of Excel 2003 Chart Wizard
  2. Enter Line Graph Data
  3. self study
  4. Line chart data selection
  5. self study
  6. Starting the Map Wizard
  7. self study
  8. Excel Chart Wizard Step 1:
  9. Select a chart from the default tab
  10. self study
  11. Excel Chart Wizard Step 2
  12. Preview your chart
  13. self study
  14. Excel Chart Wizard Step 3:
  15. Map options
  16. self study
  17. Wizard Excel Chart Step 4
  18. Chart location
  19. self study
  20. Line chart format
  21. Line chart format (continued)

Overview of Excel 2003 Chart Wizard

This tutorial will walk you through the steps to create a line chart in Excel 2003 using the Excel chart wizard.

If you follow the steps in the topics below, you will get a line chart similar to the image above.

Enter Line Graph Data

No matter what type of chart or graph you create, the first step in creating an Excel chart is: all the time to enter data into the table.

When entering data, keep the following rules in mind:

  1. Do not leave blank rows or columns when entering data.

  2. Enter your details in columns.

  • When you format the spreadsheet, list the names that describe the data in one column and to the right of that, the data itself.

  • If there is more than one data series, list them one at a time in columns with a heading for each data series at the top.

self study

  1. Enter the data as shown in the image above in cells A1 to C6.

Line chart data selection

mouse usage

  1. Drag the selection with the mouse button to select the cells that contain the data to be included in the chart.

Using the keyboard

  1. Click in the top left corner of the chart data.

  2. Press and hold a key SHIFT on keyboard.

  3. Use the arrow keys on your keyboard to select data to include in the line chart.

Make sure to select the column and row headings you want to include in the chart.

self study

  1. Select a block of cells from A2 to C6 with column headers and row headers using one of the above methods.

Starting the Map Wizard

You have two options to start the Excel chart wizard.

  1. Click on icon graph wizard on the standard toolbar (see example image above)

  2. Press Insert > Chart… on the menu.

self study

  1. Start the Chart Wizard using the method you prefer.

Excel Chart Wizard Step 1:

Select a chart from the default tab

  1. Select a chart type in the left pane.

  2. Select a chart subtype in the right pane.

self study

  1. Select chart type Line on the left panel.

  2. Select a chart subtype Line with markers right

  3. Press “Next.

Excel Chart Wizard Step 2

Preview your chart

  • After you select your data before starting the Excel Chart Wizard, you will see a preview of your chart in the top pane of the dialog box.

  • In your table, the data in the graph is surrounded by moving ants – an animated black box around your data.

  • Below the preview pane is a box with cell links to the range of data in the chart. If your chart doesn’t look right, make sure you select the correct range of data in the spreadsheet.

self study

  1. Press “Next.

Excel Chart Wizard Step 3:

Map options

While there are many options in the six tabs to change the look of your chart, we’re just adding titles in this step.

All parts of an Excel chart can be changed after you complete the Chart Wizard, so there is no need to set all formatting options now.

self study

  1. Click on the tab titles at the top of the Chart Wizard dialog box.

  2. Enter a title in the chart title field: Average rainfall in Acapulco and Amsterdam

  3. In the Category (X) Axis field, enter: Month

  4. In the Category Axis (Y) box, enter: Precipitation (mm) (Note: mm = millimeters).

  5. If the chart looks correct in the preview window, click Next.

When headings are entered, they must be added to the preview pane on the right.

Wizard Excel Chart Step 4

Chart location

There are only two options for where you want to place your chart:

  1. As a new sheet (places the chart on a different sheet from your workbook)

  2. As an object on sheet 1 (put the chart on the same sheet as your data in the workbook)

self study

  1. Click the radio button to place the chart as an object on sheet 1.

  2. Click Done.

A baseline chart is created and placed on your worksheet. The following pages describe how to format this graph to match the line graph shown in step 1 of this manual.

Line chart format

Put the chart title on two lines

  1. Click once with the mouse pointer anywhere in the chart title to select it.

  2. Click a second time just before the word Acapulco to find the insertion point.

  3. Press key ENTER on the keyboard to split the chart title into two lines.

Change chart background color

  1. Right-click once anywhere on the white background of the chart to open the drop-down menu.

  2. Click with the mouse pointer on the first option in the menu: Format chart area to open the Format Chart Area dialog box.

  3. Click on the tab patterns to select it.

  4. In section Area click on a colored square to select it.

  5. For this tutorial, choose a light yellow color at the bottom of the dialog box.

  6. Click OK.

Change background color/remove border from legend

  1. Once with the mouse pointer, right-click anywhere in the background of the plot legend to open the drop-down menu.

  2. Click with the mouse pointer on the first menu item: Legend Format to open the Format Legend dialog box.

  3. Click on the tab patterns to select it.

  4. In section Border on the left side of the dialog box, select an option Not to remove the border.

  5. In section Area click on a colored square to select it.

  6. For this tutorial, choose a light yellow color at the bottom of the dialog box.

  7. Click OK.

Line chart format (continued)

Change color/remove map area border

  1. Right-click once anywhere in the gray chart of the chart to open the drop-down menu.

  2. Click with the mouse pointer on the first menu item: Format Printable Area to open the Format Print Area dialog box.

  3. Click on the tab patterns to select it.

  4. In section Border on the left side of the dialog box, select an option Not to remove the border.

  5. In section Area click on the colored square on the right to select it.

  6. For this tutorial, choose a light yellow color at the bottom of the dialog box.

  7. Click OK.

Delete Y-axis

  1. Right-click once on the y-axis (vertical line next to rainfall) of the graph to open the drop-down menu.

  2. Click with the mouse pointer on the first menu item: Size as to open the Format Axis dialog box.

  3. Click on the tab patterns to select it.

  4. In section lines on the left side of the dialog box, select the option Not to remove the axis line.

  5. Click OK.

At this point, your chart should match the line chart shown in Step 1 of this tutorial.

Leave a Reply

Your email address will not be published.