You can use a bubble chart to plot data with three dimensions. Each data series includes a third dimension that conveys the relationship between the compared values (x and y) and a size value (z). The size value determines the size of the bubble.
By default, each data series in a bubble chart shares the x-axis value, and therefore, you need to add only two additional rows or columns of data to show another data series. If you choose to use independent x-axis values, you need to add three additional rows or columns (x, y, and z) to show another data series.
Click the Chart button
in the toolbar, click 2D or Interactive, then click the bubble chart.
Click Edit Chart Data.
The Chart Data Editor appears with placeholder data (x-axis, y-axis, and size values). Each column of a different color represents a data series that’s plotted on the chart.
To change whether rows or columns are plotted as a series, click the rows or columns button in the top-right corner of the Chart Data Editor.
If you don’t want to use the same x-axis values for each data series, click the Settings button
in the Chart Data Editor, then deselect Share X Values.
Click each cell to enter your own x, y, and size values for the data series.
To add another data series, type a new data series name in the next empty column (or row, if plotting by rows), then press Return.
When you’re done entering data, click the X in the top-left corner to close the Chart Data Editor.
Click Series at the top of the Format
sidebar on the right, click the pop-up menu below Bubble Data, then choose Bubble Area or Bubble Diameter.
To include bubbles with negative values, select the “Show negative bubbles” checkbox.