Hi Lukas,

I have chart on one sheet, I have a chart on another sheet. I know how to
set the data source to the chart.
But each week I am adding a new data (as everyone who makes charts though).
It's couple of rows with numbers that are each week (Friday) added.

Question: is there a possibility to somehow make the chart automtacilally
find the new rows and add it to the current data source? So I don't have to
do it manually...

The easiest way is to use defined names to link the chart to the data. See the
example chapter 15 from PED, available for download from my web site.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev