Dynamic display of chart labels

[kbaruin]

Hello There

I have a chart on spreadsheet. The chart is updated dynamically after pressing refresh. I wanted to display only the last lable in each series on the chart. I did this manually on the attached spreadsheet. please can anyone help how this can be done dynamically as and when the new rows are added???

Many thanks

[kbaruin]

Please can anyone help with above issue.

Thanks