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.
Open the Excel worksheet with the data you wish to chart.
Click and drag the cursor to select the data series and the categories.
Click the “Insert” tab on the command ribbon.
Click the “Column” menu to display a gallery of column thumbnail images.
Click the preferred image. The worksheet data converts to an embedded column chart.
Right-click on one data series in the plot area that you wish to convert to a scatter chart.
Click the “Change Series Chart Type” option. The “Change Chart Type” dialogue window opens with a gallery of chart images.
Click the “X Y (Scatter)” tab on the left pane. Click the preferred “X Y (Scatter)” image in the gallery.
Click “OK.” The "Change Chart Type" dialogue window closes. A combination chart displays both the column and scatter charts on one plot area.
Tips & Warnings
- Customize the combination chart with the “Chart Tools” options. For example, the Format tab contains a selection of shape styles, while the Design tab contains samples of chart layouts and chart styles. Adjust the combination chart for better readability.
- The data for a scatter chart should display “X” values in one row or column. The corresponding “Y” values should be in the adjacent rows or columns.
References & Resources
- Microsoft Office: Excel 2010, Create a Chart From Start to Finish, Step 1: Create a Basic Chart
- Microsoft Office: Excel 2010, Change the Chart Type of an Existing Chart
- Microsoft Office: Excel 2010, Available Chart Types, Column Charts
- Microsoft Office: Excel 2010, Available Chart Types, Scatter Charts