Scatter Chart
A scatter chart is produced for numeric data values that are arranged on a worksheet as adjacent rows or columns. The two groups of numbers are plotted as one series of XY co-ordinates.
To use data on a worksheet for a scatter chart, the X values should be in one row or column, and the Y values should be in the adjacent row or column.
Scatter graphs are often used for displaying and comparing numeric values, such as scientific, statistical, and engineering data to show the relationships among several sets of numeric values.
An example of a scatter graph is shown below. The data in columns A and B shows the price of coffee at the same points in time. This gives a series of values which can be plotted as a scatter diagram. Each point on the diagram represents one pair of prices.
Doughnut
A doughnut chart is similar to a pie chart, but it can be produced for more than one set of data values which are arranged in columns or rows on a worksheet.
Where a pie chart is a solid circle cut into slices, a doughnut often appears in the form of a series of concentric rings. That is rings grouped around the same centre.
Each ring of the doughnut represents a different data series, and each ring shows the data values relevant to the total of the values for that series.
