How to Make Double Line Graphs on Excel

Microsoft Excel 2010 can plot two data series on one chart area. For example, a double line chart can contain two data series that represent daytime and nighttime temperatures over a period of time. Excel’s gallery of double line charts includes six “2-D Line” and one “3-D Line.” Each data series displays a different color on the plot area. The category data displays along the horizontal axis. The value data displays along the vertical axis.

...
Double line charts indicate trends over time.

Step

Open the Excel worksheet that contains the data values.

Step

Click and drag on the categories and two data series you want to plot.

Step

Click the “Insert” tab in the Command Ribbon.

Step

Click the arrow for the “Line” button in the Charts group. A gallery of seven thumbnail charts appears.

Step

Click the preferred chart sub-type.

Step

Click “OK.” The two data series convert to a line graph. The Chart Tools Ribbon displays.

Step

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.