VBA Code to Save the file and Create a Graph

[aravindkm]

Hi All,

Could you please help in creating a macro for .csv file which needs to be saved in excel and create a pivot and line chart.

where we are manually creating a graph on a daily basis which takes lot of time.

The file needs to be included with the daily data like we have data for 01 Apr 202 as sample we will create a new file for 02 Apr 2020 which needs to be included and the pivot and graph to be refreshed automatically.

Enclosed the CSv and file sample output file for your reference.