How to Plot a Time vs. Growth Graph in Excel 2007

Written by chris loza
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel 2007 provides several options for creating graphs. To plot a time vs. growth graph in Excel 2007, Excel's scatter chart is the best choice. The scatter chart is a good representation for the time vs. growth graph because it needs two points -- one in the x-axis and another in the y-axis. Unlike the line graph, it does not plot the two points separately, but rather correlates the two points and finds the intersection point, which is the one plotted on the graph. This way, you can show the growth as time progresses in a series of points scattered in the graph.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open Microsoft Excel 2007.

  2. 2

    Place all the "Time" values in one column, for example, column A. Place all the "Growth" values in an adjacent column, column B. The "Time" values become the x-axis values while the "Growth" values are the y-axis values.

  3. 3

    Click the first cell included then drag your mouse towards the last included cell to select the range of values to be included.

  4. 4

    Click the "Insert" tab from the menu bar. Go to the "Charts" menu and click "Scatter."

  5. 5

    Click "Chart Area" to display the "Chart Tools," "Design," "Layout" and "Format" tabs.

  6. 6

    Go to the "Design" tab and select the style you want to use.

  7. 7

    Type the main title for your chart under "Chart Title." For example, you can use "Time vs. Growth" as the main title.

  8. 8

    Click the "Layout" tab and then click "Axis Titles." Select the "Primary Horizontal Axis Title" and put "Time" as the title for the x-axis. Click the "Primary Vertical Axis Title" and put "Growth" as the title for the y-axis.

  9. 9

    Press "Enter" to create the chart.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.