Hi, I am looking to update a chart at the end of a working routine. Each time
a new line is add and I only want the final four row. Here is what I have
done so far with everything I found out.

Sub MACRO1()

#line ok#Set chartrange = Range("D5").End(xlDown).Offset(-3, -3).Resize(4,
4).Activate

Here is where I got problems
Sheets("graph par qty").Select
ActiveChart.SetSourceData Source:=chartrange, PlotBy:=xlColumns

End Sub
--
Mathieu