I can imagine that creating the bubble chart area would be easy ... labelling the axes wouldn't be easy, but if you have the chart embedded in a sheet you could have cells near the chart object for the labels, if that's acceptable?
The axes go from 0 to 10 (X) and 0 to 8 (Y), with gridlines every 2 units, and with default features (ticks, labels) hidden. The X values for the bubbles are 1, 3, 5, 7, 9 and the Y values are 1, 3, 5, 7.
For x labels, I added a series with the X values above but with Y=0. I formatted the bubbles to be invisible (no fill, no outline), and added data labels using the Below position (you can add the labels manually or with Rob Bovey's Chart Labeler, free from http://appspro.com). I did the same for Y values, with the Y values from above and X=0, hid the series, and added labels in the left position.
It took me longer to type this than to make the chart.
Keep in mind that people do not accurately judge the values represented by the bubble size. If you removed the numeric labels, there would be some confusion.
I don't have time now, I'll maybe have to get back later, but try:
- right-click on one of the bubbles of the second series. This will select all the second series and display a menu where you choose "Format data series". Then
- in Fill choose No Fill
- in Line Color choose No Line
This will make the bubbles invisible
To add the labels you have to install Rob Bovey's Chart Labeler, free from http://appspro.com), as Jon said.
Next time please post your excel version. The formatting of the series may have small differences from version to version.