hi,

i want to do a bar chart for the attached. But in this case the bar chart needs to consist of only 3 bars ship1, ship2 and ship3, therefore data needs to be some how filtered/grouped. their lengths depends on the qty of material 1, 2, 3 and 4.

How can i do it?

Sorry but i could not attach the file. So thats why i attached a screenshot.

thanksworkbook.jpg