How to Do a Comparative Chart in Excel

Microsoft Excel 2010 can create charts that compare different data series on one chart area. For example, “Column” or “Line” charts can contain two or more data series for comparison. You can also mix two chart types on one plot area to help your viewers distinguish different categories. For example, a column chart can show monthly profits over time, and a line chart can show projected profits on the same plot area.

...
A line graph can contain more than one data series for comparison.

Step

Open the Excel worksheet that contains the data for the chart.

Step

Click and drag to select the data values and categories.

Step

Click the “Insert” tab on the command ribbon.

...
A column chart can display different categories or data seriesin different colors.

Step

Click the arrow for a preferred chart type in the "Charts" group. For example, a “2-D Column” chart type can display two or more data series as different colors or shades. A gallery of chart sub-types appears.

Step

Click the preferred chart sample. The worksheet data converts to the selected chart type. The chart appears with the worksheet. Each data series displays a different color. The “Chart Tools” ribbon displays.

Step

Customize the chart with the “Chart Tools” command. For example, click the “Design” tab to display the “Chart Layouts” and “Chart Styles.” Click the “Chart Styles” to convert the colors of the data series.