For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis. A simple chart consists of an x-axis and a y-axis, with the x-axis representing the various rows or ...

By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis, you need corresponding data for the X axis as well.

Adding the x-axis and y-axis labels can be done in the usual way. However, Excel has no specific tools for adding individual data labels to each bubble. You will need to add each data label ...