Thank you for your answer.

I did not succeed to generate a test workbook because when I did it it worked.

After 10 hours I solved it - during runtime one column format was changed to date format and this cause to the chart not to update when hiding columns.

Thank you