Microsoft Excel is quite useful for analyzing trends and patterns ... Select the chart, then click the Chart Design tab. Click the Select Data button. Click the Hidden and empty cells button.

AQ-IQ Mentor Xavier McIntyre explains how to import pod data (from a .txt file) into Excel. How to Import Pod Data into Excel AQ-IQ Mentor Cindy Yang explains how to create a graph without baseline ...

Streamline budget vs actual analysis with Excel tools like GROUPBY & PIVOTBY. Learn to calculate variances and create ...

You have lots of tabs in your Excel workbook ... Click any of your charts, and in the PivotChart Analyze tab, click "Insert Slicer." Select the data that you want to be changeable in your chart ...

However, once you get round the initial loading issues and how it stores certain key data, you're able to use Excel's data transformation tools to give you a way of analyzing your data.