Assistance Creating various sheets for analysis involving constantly updated data from Master sheet.

[Aruss14]

I have over 1000 rows, and it continues to grow. I wanted to know how to create charts that will update as more data is inputted to master sheet.

ie) Commodity & Approx. Sales Table
- 5 different commodities and each transaction $ worth.

I need help getting each specific commodity sales $ total, updated in real-time.

ie) Orders by commodity. How do I get this chart to update as new data is inputted?


If any one can help, greatly appreciated.

 

[losamfr17]

Why are you not converting your range into a Table to then link your PivotTables to it?
Otherwise, have you considered Power Query?

 

[Aruss14]

Why are you not converting your range into a Table to then link your PivotTables to it?
Otherwise, have you considered Power Query?

I guess I have a lot of learning to do...