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
Bookmarks