I'm facing a problem with the use of visualising relative data in a chart.
My data in the table are absolute and are correctly visualised as a relative sum (total is 100%) of counted matches if I select one set (attached figure 1). But when I select two groups of data, the result is given relative to the total amount counted, not towards the sets individually (attached figure 2).
How can I change the settings or use a formula so the two, or even three, sets are each relative to their individual sums instead of relative to the total of selected data. To be short, I'd like the sum of each of the two different bars to be 100%, without having to change anything in my original data structure.
Thanks in advance for possible solutions,