I am attaching a worksheet which has data that I am trying to graph. There are four (4) depts. I am trying to stack Departments M1 & M2 since it is really one large dept. Does anyone know how to do this while keeping the individual total production for each of these two depts . Of course , I still need the other two (2) departments on the graph, Dept OI and Dept SP.