Apr 28 2022 10:42 AM
A bit of background - I work as a data analyst for a manufacturing company. We are starting daily safety inspection checklists (things like PPE use, proper chemical storage, etc) for each area of a plant (weld shop, paint, etc).
I have a workbook setup with tabs for Mon-Fri and a sixth tab which totals the daily counts based on different categories and then a Pareto chart is built from that.
Theoretically I would have one Excel file per week from each department at a given plant. How would I create a plant-wide chart which combines the totals from each department workbook? I'd prefer to use just formulas or something like Power Query and stay away from VBA or scripting. Any thoughts or links to a tutorial would be amazing.
Apr 28 2022 10:55 AM
Apr 28 2022 11:19 AM
Apr 28 2022 11:49 AM
Apr 28 2022 12:03 PM