Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data
See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Powery Query
Step Method, and then make an amazing Pivot Chart with Dynamic Labels:
- 1. Problem Setup
- 2. Import multiple Text Files (Tab Delimited) from a single Folder
- 3. Build 3 PivotTables for 3 Class Grade
- 4. Chart with Custom Labels
- 5. Create Labels for chart that are connected to the PivotTable and Cells. Text formulas with TEXT and CHAR functions.