Bubble Chart Excel

[mrNIPE]

Hi all,

I have a few questions for a bubble chart that I am working on and really hope that one of you can help me:

1. I want to have the numbers on the axis portrayed in between the grids as shown with red text below. For now I have just made a quick fix by inserting a text box, but this is obviously not optimal. Does anyone know how to incorporate such formatting?
2. The data bubbles should be centered within their respective grids. Have tried to show how with the green bubbles (J). For example: Bubble F has a value of (3.7, 0.8) and Bubble C has a value of (3.1, 0.2) but should both be centered in grid (4, 1). Thus each bubble are put in grids based on their respective values, however they are not ranked further in between these grids. Does it make sense? Anyone that know how to fix this?

Hope to hear from you - thanks a lot in advance!

Best regards,
Nikolaj

 

[OaklandJim]

I can't promise that I can do this but I'll try. If not me then possibly other people who are smarter about Excel.

If you want assistance you are more likely to get help if you help the helper so they do not need to guess about or recreate your data.

If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the Mr Excel message area. Make sure that other people can access the file!

Or, consider sharing relevant data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. See XL2BB - Excel Range to BBCode for details.