How to Do a Comparative Chart in Excel

1. Open the Excel worksheet that contains the data for the chart.
2. Click and drag to select the data values and categories.
3. Click the “Insert” tab on the command ribbon.
4.
A column chart can display different categories or data seriesin different colors.
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.
5. 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.
6. 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.