Hi ,
Basically the 2 chart series and the horizontal axis are now referring to named ranges credits , debits and Row_Labels.
If you click on the Name Manager , you can access these named ranges and see what they are referring to.
You need to ensure that the Pivot Table does not have the Grand Total row.
When using the named ranges in charts , go into Select Data , and in the box for the series enter the named range including the sheet name , as in :
=Sheet1!credits
Excel will automatically replace the sheet name with the complete name inclusive of the workbook name.
Narayan