Create automated graph in Excel 2016
 

Hello all,

I'd like to know if it's possible to create an automated chart in excel, so when I enter the required data in a specific column, the chart automatically updates and gives a total figure. I should also mention that I will be dealing with multiple tabs and pulling the data from our system at the end of each month

Thank you 🙂