Using the data in the Alphabet Financials xlsx workbook that was used in the chapter Create a pivot chart that shows the current ratio over time Has Alphabets liquidity deteriorated or improved over this period Insert a trend line into the chart to verify your results Now, use a Timeline to filter ...

Answer 1 When creating a pivot chart to show the current ratio over time for Alphabet Financials it ...

Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter: Create a pivot

Fantastic news! We've Found the answer you've been seeking!

Using the data in the Alphabet Financials.xlsx workbook that was used in the chapter:
1. Create a pivot chart that shows the current ratio over time. Has Alphabet’s liquidity deteriorated or improved over this period? Insert a trend line into the chart to verify your results.
2. Now, use a Timeline to filter the pivot table so that it only shows 2018 to 2019. Now show only 2013 to 2014. Is there a difference in the trend of the current ratio in the two time periods?