title: Remove the blank row values in chart
body: <p>I am generating a chart from table. the table rows are not completely filled. </p>
  
  <p>so when I am generating an chart, I get the value of not filled columns also as "0". I would like to remove the "0" (value of blank rows") in my chart. Is
  there a way I can do this? any lead would be helpful</p>
  
  <pre><code>Sub chartResult()
  Dim rng As Range
  Dim cht As Object
  Set rng = ActiveSheet.Range("B2:D53")
   ThisWorkbook.Sheets("Result").ChartObjects.delete
   Set sh = ActiveSheet.ChartObjects.Add(Left:=440, _
      Width:=600, _
      Top:=340, _
      Height:=250)
   sh.Select
   Set cht = ActiveChart
  With cht
   .SetSourceData Source:=rng
   .ChartType = xlColumnClustered
  End With
   cht.SeriesCollection(1).name = "Ov"
   cht.SeriesCollection(2).name = "O"
   cht.SeriesCollection(3).name = "To"
  
   cht.SeriesCollection(1).HasDataLabels = True
   cht.SeriesCollection(2).HasDataLabels = True
   cht.SeriesCollection(3).HasDataLabels = True
   cht.SeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(72, 118, 255)  '&lt;~~ Red
   cht.SeriesCollection(2).Format.Fill.ForeColor.RGB = RGB(255, 0, 0)
   cht.SeriesCollection(3).Format.Fill.ForeColor.RGB = RGB(0, 167, 0)
   cht.HasTitle = True
   cht.ChartTitle.Text = "Result "
  End Sub
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/siCiU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/siCiU.png" alt="this is the sample image of my graph. I would like to remove all the zero values.IS there a way  could do"></a></p>