Sum and show top n columns according to row selection

[Anonymous]

Hello,

I'm trying to figure out a pretty simple thing, but I'm stuck. I have a simple spreadsheet that contains rows with calendar week and a lot of columns where individual errors and their proportion are marked.
I would need to create a bar chart where specific weeks(rows) are selected and the top N errors are displayed based on the sum of the percentages in those weeks.

Data which I have:

Kind of chart which I want to get: (errorZ,errorE... represents name of the columns)

Could you please help me?

Thanks a million

[pratyashasamal]

Hi @Anonymous ,
You use waterfall chart for this . For example :-

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Anonymous]

Hi,

thank you very much for the answer, my thought was more how to transform the data I have in the table into the chart based on the top N columns (errors) - based on sum and selected rows (calendar weeks)