How to Combine Column and Scatter Charts in Excel

Microsoft Excel 2010 can create a combination chart that includes both column and scatter charts on one plot area. Displaying two chart types can help others who view your spreadsheet to distinguish and analyze the different data series. The “Insert” tab on the command ribbon creates one chart type, while the “Change Series Chart Type” option creates the second chart type for the second data series. Use the “Chart Tools” commands to customize your combination chart for better readability.

...
A combination chart can illustrate different data series.

Step

Open the Excel worksheet with the data you wish to chart.

Step

Click and drag the cursor to select the data series and the categories.

Step

Click the “Insert” tab on the command ribbon.

Step

Click the “Column” menu to display a gallery of column thumbnail images.

Step

Click the preferred image. The worksheet data converts to an embedded column chart.

Step

Right-click on one data series in the plot area that you wish to convert to a scatter chart.

Step

Click the “Change Series Chart Type” option. The “Change Chart Type” dialogue window opens with a gallery of chart images.

Step

Click the “X Y (Scatter)” tab on the left pane. Click the preferred “X Y (Scatter)” image in the gallery.

Step

Click “OK.” The "Change Chart Type" dialogue window closes. A combination chart displays both the column and scatter charts on one plot area.