Three Series Bar Chart

M

mr.emunson

New Member
Joined
Dec 10, 2010
Messages
22
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
 
Sort by date Sort by votes
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

62170975.jpg

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



​
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Is it accurate that Excel's 'forecast sheet' function can only work with one series at a time?
Replies
2
Views
359
Jon Peltier
J
B
  • Question Question
Chart help - rainfall data
Replies
2
Views
469
JV0710
J
N
  • Solved
Add data to column chart so that it becomes a stacked column chart
Replies
2
Views
575
Nick70
N
J
  • Question Question
Stacked Clustered Column Chart
Replies
0
Views
333
johnnypp
J
D
  • Question Question
Creating Gantt Chart
Replies
0
Views
294
dwscrippler
D

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top