Excel - Scatter Charts

To create a scatter chart with an optional second series and automatic data labels, select the first series of chart data, including labels. A second series can be added at a later stage.

Select New Chart in the ribbon or side bar.

• In the Chart dialog, select Scatter and in the sub chart type list on the right select either:
  • XY Scatter Single Series 
  • XY Scatter Single Series Coloured
  • XY Scatter Multi Series
• Select the required custom chart theme from the dropdown (the chart will be formatted accordingly).
  
• Click OK.

The Custom Chart Wizard will open with the fields populated based on your selection.

• Edit any of the fields by clicking on the button at the end to collapse the dialog and selecting the correct data or for titles, typing the text in manually.
• To add a second series of data, select the data on the worksheet first and then choose Add Series.
• Click OK.

The formatted chart will appear on the worksheet.

Save the workbook. Send to PowerPoint or Word using Quick Send.