How to Make a Scatter Plot in Powerpoint

Scatter charts and bubble charts are similar in many aspects, both using an xy-plot to visualize datasheet contents. The charts differ, however, in the style of markers used for the individual data points.

The datasheet for a besprinkle chart is organized equally follows, with each row representing a single data point:

The datasheet for a bubble chart contains values in the Size column, but is otherwise organized identically:

The Group column in the datasheet can exist used to organize private information points into groups. In the in a higher place scatter chart datasheet, the start three data points belong to group A while the remaining data points belong to group B. Multiple data points belonging to the same group can be easily selected by clicking on a data point then moving the mouse pointer while holding down the Shift key (see Multi-option).

The axes of scatter charts and chimera charts tin besides exist adjusted. Delight refer to Scales and axes for details. Yous may also use dates for the Ten or Y values. When all cells in the datasheet for one centrality contain dates and Excel'south cell format is set to Date, and so the tick mark labels of this axis bear witness dates and you can format them accordingly (see Date format control).

If Employ Excel Fill up on Top is selected (come across Colour scheme), you lot can set the fill color from Excel'due south cell formatting in whatsoever cell in a information signal's row to set the color for this data point's mark.

12.1: Labels
12.2: Scatter chart
12.three: Bubble chart
12.four: Trendline and partition

12.1 Labels

In both chart types, upward to ii labels can be associated with each data point. Labels can be added using the Add Characterization button and removed using the Remove Labels button. The characterization content control lets you select the format of the text field for each characterization, allowing the display of the label text besides as the x, y and size values (encounter Label content). By default, labels are disabled in charts containing more than than 300 data points. If required, they can be enabled using the context menu.

The automatic labeler places labels every bit shut to their data points equally possible, using connecting lines if necessary (run across Automatic label placement).

While the labeler is busy calculating the label placements, a rotating progress icon appears in the upper left corner of the chart and the concerned chart is highlighted with a light gray frame. You lot can save the file or proceed to piece of work on other charts or slides while the labeler is running.

In rare circumstances the labeler may not notice an optimal placement for all labels. When this happens, manually placing labels will help. Attempt to manually place one of the poorly placed labels and let the labeler automatically identify the remaining labels. An acceptable placement for all labels can unremarkably be achieved by manually placing just a few problematic labels.

12.2 Scatter chart

Icon in Elements menu:

The scatter chart uses the marking scheme control to consistently mark data points belonging to the aforementioned group (run across Marker scheme). The marker shape control tin be used to fix the marker shape for individual data points (see Marker shape).

If y'all choose No Markers in the marker scheme control, the markers for the information points are switched off. In this example the labels are centered on the position of the data points. However, the automatic label placement may showtime the labels from this position to forestall overlap.

Information technology is not possible to both switch off the marker and hibernate the label for a data point.

12.iii Bubble nautical chart

Icon in Elements carte du jour:

The bubble chart is a variant of the scatter chart, with data points marked past circles. The circle sizes are determined by the values in the Size column. Past default, the Size value is proportional to the area of the circle. The Make Bore Represent Size button in the context menu can be used to fix the Size value to be proportional to the bore of each circle.

To enable a legend of the chimera size, click Add together Bubble Size Legend in the chart's context menu. To alter the bubble size used in the fable, select the bubble and drag the handle that appears on the right boundary.

think-cell bubble size legend adjustment

When you select i of the bubbles inside the nautical chart, a like handle appears on the right boundary. Change the bubble size by dragging it. All other bubbling are scaled appropriately, as the ratio between bubbles is always determined past the numbers in the datasheet's Size column.

When two bubbles overlap, the smaller bubble will be shown in front of the larger one. To alter the guild, choose Bring to Front from a bubble's context carte du jour.

12.4 Trendline and partition

In menu:	Nautical chart, information point
Menu item:

12.4.1 Trendline

In scatter or bubble charts you can let recollect-cell calculate a trendline for a group of values. A trendline is a graphical representation of trends in the group. They are used for the report of bug of prediction, likewise called regression analysis.

The trendline is calculated using linear regression then that the sum over all points of the quadratic difference betwixt the Y coordinate and the trendline value at the X coordinate is minimized. In a bubble nautical chart, the bubble size is used to weight each betoken'south contribution to the departure.

At that place are two ways to add a trendline to the nautical chart:

Right-click a mark or a bubble of the desired group and select Add Trendline from the context menu.
Select a partition line (run into Sectionalisation). In the toolbar you tin can choose a group of values and the line is changed to a trendline for this group.

think-cell scatter chart / bubble chart trendline

You can choose the type of trendline from the trendline blazon control in the trendline's contextual toolbar. The Linear type is the default and always available. In the scatter chart, when the trendline is calculated based on a specific group (All groups is not set), and no fill color and centrality breaks are used, then additional trendline types are available:

Power: Fits best when there is a ability police force human relationship between Y- and X-values.
Exponential: Fits best when at that place is an exponential relationship.
Logarithmic: Fits best when there is a logarithmic relationship.

The post-obit example illustrates the proficient fit of a Power trendline in a scatter nautical chart where the Y-values are squares of the X-values:

think-cell scatter chart power law trendline

You can change the background colour on one side of a linear trendline and move the line in the same fashion every bit for a segmentation line (see Partition). However, once you have moved the line, information technology will no longer be calculated from the values in the datasheet.

12.four.2 Partition

You lot tin add a partition line to scatter or bubble charts to signal upwardly a partition of a set. To add a sectionalization line, select Add together Trendline/Partition from the chart'southward context menu.

You tin movement the line past clicking on information technology and dragging it to the desired position. Information technology is too possible to select the partition line and then drag the handles at the get-go or end of the partitioning line. While dragging, the cease points will snap to dainty values. The spacing of the snap points depends on your current zoom level. If y'all concur down the Shift key while dragging, the angle of the division line is constrained to the current angle or to that of a vertical, horizontal or diagonal line.

To make a copy of a partition line, hold down the Ctrl key while dragging. This is an like shooting fish in a barrel way to create parallel lines, e.g. to marker a range of values.

You lot can change the background color of a set by clicking on the sectionalization line and selecting a groundwork color from the toolbar. To set the background color of the surface area on the other side of the line, right-click the partitioning line and select Flip Filled Side. You can also simply double-click the segmentation line.