Using Dynamic Ranges for Excel Charts

I see your issue. When you add lines, and want to update the chart, you have to go back and put in the new range, by simply typing in ChartNoNA. The only way around this is running a macro. I created one by using record.

Sub Macro1()
'
' Macro1 Macro
'

'
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.PlotArea.Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.SeriesCollection(3).Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.SetSourceData Source:=Range("ChartNoNA")
   ' ActiveChart.SetSourceData Source:=Range("B2:AX11")
End Sub

See the attached sheet, I made it run when you change something on the worksheet.

When you insert rows, it will give you a small error about #REF, but when you hit OK, the chart is updated.

You must enable macros security settings.