Three Series Bar Chart

[mr.emunson]

Good Afternoon,

I am trying to create a bar chart that uses three series of data and have been unsuccessful; any recommended solutions will be greatly appreciated!

Details:
I am attempting to create a bar chart that shows employee hires (monthly actual results) versus the employee hire forecast (forecasted monthly hires). Where it gets tricky - within the "actuals" bar chart I would like to break the bar into two categories: 1) Full-time employees and 2) Contractors.

Example Data (One month):

Nov. F/T employees (10) / Nov. Contractors (2) / Nov. Forecasted Hires (14)

Using this example data the bar chart would compare a (12) employees hired against a forecast of (14) employees. Within the (12) hired employees; the bar chart would have 10 F/T employees and (2) Contractors.

I hope that is clear - again any and all help will be appreciated!

Cheers,
Eric

 

[Robert Mika]

Use a stack bar chart:

Data layout:
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">F/t</td><td style=";">Contr</td><td style=";">Forecast</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style=";">September</td><td style=";">Actuals</td><td style="text-align: right;;">10</td><td style="text-align: right;;">2</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">
</td><td style=";">Forecast</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">12</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style=";">October</td><td style=";">Actuals</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">
</td><td style=";">Forecast</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">14</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style=";">November</td><td style=";">Actuals</td><td style="text-align: right;;">5</td><td style="text-align: right;;">9</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">
</td><td style=";">Forecast</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">19</td></tr></tbody></table>

Chart

Based on:
http://www.andypope.info/charts/stackside.htm



​