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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
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

N
  • Solved
Add data to column chart so that it becomes a stacked column chart
Replies
2
Views
333
Nick70
N
D
  • Question
Creating Gantt Chart
Replies
0
Views
171
dwscrippler
D
F
  • Solved
Excel formula needed
5 6 7
Replies
66
Views
2K
KRice
K
J
  • Question
Not sure if Excel can do this...
Replies
1
Views
557
Sam_D_Ben
S
L
  • Question
Chart Question
Replies
2
Views
257
awoohaw
awoohaw

Forum statistics

Threads
1,214,994
Messages
6,122,633
Members
449,092
Latest member
bsb1122

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