Help me filter in barchart?

[horsefish01]

I have this book.

Can someone help me so that I can get the possibility to compare the columnheaders in my chart?

So I could compare example ACC1 and ACC4 if I wanted, or ACC8->ACC12

MappePhoner.xlsx

[Immortal2014]

Can you explain it little better? You want the total of each row from acc1 to acc12?

[Andy Pope]

You could use a pivot table/chart.

I added random data to the other accounts so you can see some output.

[MartaLoskot]

You can use chart wizard, I am using it and its quite reliable.

[horsefish01]

You could use a pivot table/chart.

I added random data to the other accounts so you can see some output.

This is great. Thank you.

Is there someway I can get slicers to toogle only between ACC's as whole? When I make slicers now, it makes 12 with all data from the ACC's

[Andy Pope]

You would need to alter the layout of your data, see sheet3 and sheet4.