How to Make Double Line Graphs on Excel

1. Open the Excel worksheet that contains the data values.
2. Click and drag on the categories and two data series you want to plot.
3. Click the “Insert” tab in the Command Ribbon.
4. Click the arrow for the “Line” button in the Charts group. A gallery of seven thumbnail charts appears.
5. Click the preferred chart sub-type.
6. Click “OK.” The two data series convert to a line graph. The Chart Tools Ribbon displays.
7. Customize the chart with the commands in the Chart Tools Ribbon. Chart Tools contains three tabs: “Design,” “Layout” and “Format.” Experiment with the commands in each tab to increase readability and add visual interest. For example, the Design tab contains 12 chart layouts and 48 chart styles.