I get mad by trying to fromat my chart series correctly.

I consists of 2 series beside those of class 1 and the other one of class 0.
When I select one bar from class 1 using “format data series” it justs selects a weird mixture of values from class 1 and 0.
When I select one class from the data selection and then apply e.g. a color change, this will also apply to the unselected class.
How can one do the job correctly?

P.S. the data comes from a pivot table, apparently that makes the difference.
I get the same weird behaviour from Office 2019 equally on Mac or Windows.

​I get mad by trying to fromat my chart series correctly.I consists of 2 series beside those of class 1 and the other one of class 0.When I select one bar from class 1 using “format data series” it justs selects a weird mixture of values from class 1 and 0.When I select one class from the data selection and then apply e.g. a color change, this will also apply to the unselected class.How can one do the job correctly?P.S. the data comes from a pivot table, apparently that makes the difference.I get the same weird behaviour from Office 2019 equally on Mac or Windows.  Read More

​