Repeatable line graph from series, wid % change, product name from table, on Graph title

Dear folks

Good day

Happy to see such a friendly and nice forum

I need to make a simple & Repeatable line graph from series, but get the % increase & product name etc picked up from Table and mentioned on the graph Table

The table looks as follows

Part Description Created Cost - USD / pack % incr
The great Blue paint 06-Dec-20 15.46
The great Blue paint 10-Dec-20 15.66
The great Blue paint 10-Dec-20 16.07
The great Blue paint 10-Dec-20 16.07
The great Blue paint 10-Dec-20 15.66
The great Blue paint 15-Dec-20 16.10
The great Blue paint 23-Dec-20 15.78
The great Blue paint 30-Dec-20 15.69
The great Blue paint 06-Jan-21 15.44
The great Blue paint 06-Jan-21 15.44
The great Blue paint 10-Jan-21 15.72
and so on ...

All I need is to repeat this graph 100s of times, with different data, which I can provide at one go and the VBA does a filter and loop on colum A or I can provide the data manually provide multiple times but the product name, the growth etc picked up from the table and the Y axis auto adjusted on the graph

I thought PIVOT Graphs would do, but that isn't auto displaying / adjusting as I thought

Sample spread sheet enclosed

thanks in advance for your help
regards
Subu