The data is plotted as bubbles of varying sizes - the larger the bubble, the higher the total sales amount (z). The bubble chart below shows how the number of units sold (y) varies with the number of salespeople (x). If you select to use independent x-axis values, you need to add three additional rows or columns (x, y and z) to show another data series.
SCATTER CHART EXCEL USE NUMBERS RATHER THAN DOTS SERIES
The size value determines the size of the bubble.īy default, each data series in a bubble chart shares the x-axis value, so you need to add only two additional rows or columns of data to show another data series. Each data series in a bubble chart includes a third dimension that conveys the relationship between the compared values ( x and y) and a size value ( z). The scatter plot below shows the correlation between driving speed and mileage (litres per kilometre).Ī bubble chart is a type of scatter plot in which the data are plotted as bubbles of varying sizes, rather than as points. By default, each data series in a scatter plot shares the x-axis value and therefore, you need to add only one additional row or column to show another data series. They display data as points and require at least two columns (or rows) of data to plot values for a single data series. Scatter plots show relationships between two or more sets of data. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename or delete paragraph styles.Bold, italic, underline and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Add a legend, grid lines and other markings.