I do not have access to the source data as this is taken care by my another group of colleagues as they are in the midst of transiting from old system to new system. The data will be stored in MS SQL server though.
This is the format that my users are currently using in Excel.
Sum of rows or columns is quite possible as that is a standard feature as well. I deliberately excluded that since in my data it does not make sense to sum it up. Showing here only for your reference that it can be done in Qlik Sense.
If you can share any sample data and your chart's details, I can provide more specifications on how to get it done.