Add Grand Total Legend to Pivot Chart

Hi All,

I have a cool timeline expiration spreadsheet attached.

My question lies on the first tab. Is there a way for me to sum up the total of all the bars into a simple legend? i.e. Total Base Rent Expiring, Total Area Expiring

Also, is there a way to hide the count of sum bar, while keeping it in the data table below the chart?

I appreciate all the help guys.

Best Regards,

GB