I have reviewed your work and my comments are given as followings:
1. On sheet 1, cell C43, a formula is missing.
2. You may misunderstand the purpose of Pivot table and Pivot chart. I expect that you use the table and chart to show the ages of outstanding accounts receivables by the types of customers (X, Y and Z).
3. When you prepare the Pivot chart, you should have the titles for the chart, the X-axis and the Y-axis.