Facing problem with Bubble Chart

1- I have created only with series with 30 entries, but bubble chart is showing only 27. My question is why it is not showing all 30 bubbles?

I see all 30 bubbles in your chart. I note that you have 3 duplicate points (points 3 and 5 are the same 5,4,0.18 for example), and these points will not be distinguishable on the chart, but they are there.

2- When I select the bubble within bubble chart, all bubbles are not selecting at once.

I am not sure I understand your concern here. Excel has always minimized display effort when "highlighting" a data series with a lot of points by only displaying the highlighting around some of the points.

3- I want to color them as per the criteria. I am using the VBA code, but unable to change the color of all the bubbles according to criteria. Any help

Not sure exactly what your question here is. The code seemed to work just fine, other than 1) My older version does not support the FullSeriesCollection object, so I had to change to the SeriesCollection object 2) The comment and code claim that colors are in column R/column 18, but the sample sheet has the colors in column G/column 7 3) The code starts in row 1+1 = row 2, but the data in your sample sheet start in row 4. Correcting those three minor errors caused the code to run perfectly. I suspect that these are related to trimming the sample sheet down from the original, so these changes should probably not be needed in your original.

4- How to display if there are more than 100 values o bubbles

You will probably need to recommend something and we'll help you program it. I have no idea what you might want. If you need a wild first guess, put =IF(COUNT(B4:B400)>100,"many points","not many points") into B2 and tell us what you like and don't like about that way of indicating more than 100 points.