How to Mix Chart Types in Excel

1. Open the Excel worksheet.
2. Click and drag to select the categories and data values for the charts.
3. Click the “Insert” tab on the command ribbon.
4. Click one preferred chart type in the “Charts” group. The data converts to one chart type. The “Chart Tools” ribbon appears.
5. Right-click one data series in the plot area. This selected series will display a different chart type. A list of options appears.
6. Click “Change Series Chart Type” in the list. The “Change Chart Type” dialog window opens with a gallery of chart thumbnails.
7. Click the preferred chart type.
8. Click “OK.” The data series converts to a new chart type.