Many a times it is very difficult to determine if chart is exists. Also it is very time consuming to check all sheets in workbook to check for a specific chart. So, checking charts in project will be a one of the data validation and performing this activity is manually is a quire tedious job. But, we can make this task very simple by using a short code which will help us to check if chart is exists.

By using VBA code in project to validate charts existence is very powerful and accurate method for graphical data representation. Which certainly saves a huge amount of time while data validation.


Here is the code which will easily validate if chart/graph is exists in Workbook:

Sub Chart_Is_Exists()

' Author: Dreams24
' Written for VBA Tricks and tips blog
https://www.vbatricksntips.com

Dim i As Integer
Dim nChart As String

' Name of chart to check

nChart = "Test_Chart"

'for loop to check chart existence in each sheet


For i = 1 To ThisWorkbook.Sheets.Count    

      On Error Resume Next        
      Sheets(i).Activate    Sheets(i).ChartObjects(nChart).Activate        
        If Err.Number <> 0 Then        
             MsgBox "No Chart Exists In " & ActiveSheet.Name, vbInformation       
             Err.Clear    
        Else        
             MsgBox "A Chart Does Exist In " & ActiveSheet.Name, vbInformation    
        End If
Next i

End Sub