Advanced Excel Chart Question

Copper Contributor

I've got a chart showing Planned Headcount for the year as well as actuals for salaried and hourly. It's a combo chart where the planned is two lines with markers (one hourly and one salary) and the actual is a clustered column (again one hourly and one salary). I would like to stack hourly and salary current open reqs on top of the clustered columns for each of the actual headcount numbers. Is this possible? The attached shows an example. The actual are stacked but the hourly and salary are supposed to be stacked next to each other and not on top. Appreciate the help.

2 Replies

@kellielacabanne 

Do you mean like this?

image.png

 

@Sergei Baklan Kind of, but is it possible for the hourly and salary columns to be next to each other instead of side by side?

Like the 2nd tab on the attached except adding the hourly open and salary open to the relevant stack?