How to Make a Line Graph From a Data Table
- 1). Open the Excel worksheet.
- 2). Click and drag to select the data and categories on the worksheet. A dark outline appears around the range of cells.
- 3). Click the "Insert" tab on the command Ribbon.
- 4). Click the "Line" arrow in the "Charts" group. A list of chart thumbnails appears, such as "2-D Line" and "3-D Line."
- 5). Click the "Line" button from the "Line" section. The data converts to an embedded line graph that hovers over the worksheet. The "Chart Tools" ribbon appears.
- 6). Edit the chart using the buttons in the "Design," "Layout" or "Format" tabs, if preferred. The "Design" commands affect the line colors. The "Layout" commands can insert picture files, text and titles. The "Format" commands change the chart's outline and text formats.
Source...