Remove or Hide or Delete Negative Bubbles

[technicalupload]

Hi Rajan:

Hope you are doing good.

In a data sheet we have negative values. I dont wanna see them in my bubble chart. Please let me know how to eliminate the negative bubble in the Bubble Chart.

Please find attached the dummy sheet (Data and Chart)

Thanks in advance.

[Rajan_Verma]

hi,
what kind of solution do you need,VBA? Without VBA?

[technicalupload]

hi,
what kind of solution do you need,VBA? Without VBA?

VBA only ie for active chart if there are any bubbles with negative values delete or hide them

Regards

[Rajan_Verma]

i have seen that file.. You just need to replace Negative values by #N/A, All negative points will be hidden on chart

Thanks
Rajan

[technicalupload]

Yes Rajan!, Also please dont use Hide/Unhide alogrithm.

Thanks

[Excel Fox]

Try this

Sub HideBubble()

    Dim obj As Series, intI As Integer
    
    For Each obj In ActiveSheet.ChartObjects(1).Chart.SeriesCollection
        For intI = 1 To obj.Points.Count
            If obj.Values(intI) < 0 And obj.XValues(intI) < 0 Then
                obj.Points(intI).Format.Fill.Visible = msoFalse
            End If
        Next intI
    Next obj
    
End Sub

[Excel Fox]

Also, please ensure you start a new thread for a new query, unless it is exactly in line with what was being discussed. You may add a reference to the original thread if need be. I've moved this to a new thread.