How to Make a Line Graph in Microsoft Excel

A line graph provides an easy method to display information as well as compare like information from multiple periods of time or divisions. Creating a line graph in Excel is a relatively easy task, as long as you select the correct data to derive the line. Once you've got the data set, move into the creative portion of your data review by creating line graphs that best represent and convey the information from your spreadsheet.

Instructions

    • 1

      Arrange the data in either rows or columns. Excel makes the decision as to how to best graph the line based on the data input you provide. You need at least two sets of data to create the axes for your chart. For example, build a line graph using one row or column that provides time periods, such as months or quarters, and the other row or column listing gross sales.

    • 2

      Select the data in the rows or columns to include in the line chart. Click and drag your mouse across the data in the Excel spreadsheet to include it.

    • 3

      Click the Insert tab and review the available types of Chart. Select "Line" from the options offered.

    • 4

      Review the embedded chart in your spreadsheet. To move the chart to its own sheet, select it. The Chart Tools display, which adds several tabs, including Design, Format and Layout. From the Design tab, click "Move Chart," which resides in the Location group. Select "New sheet" from the "Choose where you want the chart to be placed" options.

    • 5

      Modify the title, which defaults to "Chart1" by selecting the Layout tab. In the Properties group, click the "Chart Name." Enter the name and press the "Enter" key.

    • 6

      Modify the layout by using a pre-determined format from Excel. Select the line chart. The Chart Tools become available. Select from among the options available in the Chart Layouts group from the Design tab.

    • 7

      Add titles to the axis. Click the chart to active the Chart Tools. From the Layout tab, review the Labels group. Select "Axis Titles," and enter the axis name for the primary horizontal and vertical axes.

Tips & Warnings

  • Line graphs in Microsoft Excel can display multiple lines for multiple sources of data. Provide one column of information for each type of data to include in the line graph.
Related Searches

References

  • Photo Credit Medioimages/Photodisc/Photodisc/Getty Images

You May Also Like

Related Ads

Watch Video

The 2014 Holiday Gadget Roundup