Scatter Plot with Connected Markers

Use this professionally formatted XY Scatter Plot PowerPoint template to analyze how one variable impacts another and show correlation between two variables. Create professional data visualizations effortlessly and fast.

Chart Template for PowerPoint

In this template, percentage values are derived from absolute numbers using formulas. 

Chart Type

Scatter Chart / XY Scatter Plot

Chart Function

Correlation, Pattern

How to use and edit this chart template

To edit this chart template, execute following steps.

  1. Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
  2. Enter variable 1 data in column A. These values form the X-axis of the scatter plot.
  3. Enter variable 2 data in column B. These values form the Y-axis of the scatter plot.
  4. Variable 2 data values are automatically converted into percentages using formulas in the data setup. They are shown using pre-formatted auto-placed connected markers with data values.
  5. You can add your data manually or copy data from Excel or any other data source. 
  6. Close the Excel sheet.
  7. Restyle and customize to change text, fonts, colors etc. to match your brand guidelines, corporate identity / corporate design and preferences. 
  8. Modify the template for your own use case, industry or job function. Easily change, add or delete categories and corresponding data series, if you have more/less data than provided in this ready-to-use template.
  9. File format: PPTX. Compatible with PowerPoint 2013 and above.

Use case example: Follow-up to win ratio

The XY scatter plot in above example analyzes 243 deals closed during a period and their correlation with number of follow ups. The chart plots number of client follow ups on X-axis and corresponding number of deals closed on Y-axis. The connected markers show percentage of deals closed at each follow up stage.  

From the chart, audience can easily see that 61% of the deals got closed between 5th and 10th follow-up, with 14% at the 7th follow-up. This analysis emphasizes importance of multiple follow-ups and optimum number of follow ups for better results. 

 Also see bullet chart template to visualize proposals to sales closure ratio and panel chart template to compare lead to conversion ratio.

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Numbers have an important story to tell. They rely on you to give them a clear and convincing voice.

Stephen Few

Create Beautiful Custom Reports, Dashboards, Charts and Graphs in Minutes

115 Chart Templates . One time purchase . instant download