Sparklines updating automatically as I add Data?

Hello Gurus,

I have a table, simple with my Units (companies) and 20 weeks of revenues.
I'm only at week 10 and the sparklines I have show all 20 weeks (with no value week 11-20)

I was wondering if it's possible to have sparklines add a week only when I put numbers in?

File attached

Thanks

Hello
I think it is better to resort to VBA.
Enter this code in the class module of the sheet concerned

Please Login or Register  to view this content.

I attach my file. By inserting / modifying / deleting one of the data in the range C5:V19 the graphs adapt.
Hello,
Mario