Excel macro to track daily metrics input over time into graphs

I’m looking for an excel macro that I could input Daily business metrics such as team and floor performance that can be logged directly into graphs to track the data over the year it would have two charts that track team rate, takt,nsta,upf, oowa with red yellow and green indicators for the values in each and would track them for each P1,P2, and EOS and the same chart to track the entire floor performance than another 2 charts that tracks the top five Associates from both the team and floors would track the top five associates logins their Associated rates and units and a button to log the info into a bar graph to track the floor/team numbers as well as the AA logins how many times they got top five and top rate/units overall for each