How to Make a Bubble Graph on Excel

1. Open a new Excel 2010 spreadsheet.
2. Click on cell 'A1' and type in the title for your first set of data. This data will be shown along the 'X' axis on your bubble graph. Once the title is in place, enter the data into the cell in column 'A.'
3. Select cell 'A2' and enter the title for the second set of data. This data will make up the 'Y' axis on your graph. Once the title is in place, enter your data into column 'B,' underneath the title.
4. Click on cell 'C1.' Enter the title for your third set of data. This set will be represented by the size of the bubbles on your graph. Once the title is in place, fill out the rest of column 'C' with your data.
5. Click on cell 'A1' and hold down the mouse button. Drag your mouse down to the last cell in column 'C' and release the button.
6. Click 'Insert' at the top of the screen. Locate the 'Charts' area of the ribbon and click the 'Other Charts' button found there. Select 'Bubble' or 'Bubble with 3D effect,' depending on how you want the chart to look. The bubble chart will appear on your spreadsheet.