#Install Module Install-Module -Name ImportExcel #Load Module Import-Module ImportExcel #Pull Video Library Files Info Get-ChildItem -Path 'D:\All_Movies' -Recurse -FIle | Select Name, Length, Extension | Where Extension | #Export Media Files Info to Excel #Create Pivot Table #Create 3D Pie Chart Export-Excel 'C:\temp\Movie_Files_Export.xlsx' -show -includePivotTable -PivotRows Extension -PivotData @{Length="sum"} -includePivotChart -charttype PieExploded3d