Combining bars

[Jasco]

I have a set of actual values and project values for Years
01-03. For 03 I have actual and forecast. I can create a
chart that has one bar for each item. However I need to
stack only the F03 actual and forecast values into one
bar. Is this possible?

01 02 03 Fcst 03 Act 04 Proj
205 215 241 261 304
4.6% 4.9% 12.1% 8.3% 16.5%



Thanks,
Jason

 

[Nicky]

I'm not sure how you want to present the data. Stacking the actual an
expected 03 data would be easy, but you'd get a very high column.

Is this what you're after

Attachment filename: tiered x.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45701

 

[Jasco]

I would like the 2003 forecast and actual to be on one
column instead of two. The first 241 in one color and the
next 20 (261-241) in a different color. My current report
looks like the one you created. I have been unsuccessful
in combining the two individual columns into one.

Thank you for your help.
Jason

 

[Andy Pope]

Hi Jasco,

Lay your data out (A1:E4) like so, where <Empty> is simply a placeholder
for this email and should just be an empty cell in your worksheet.

<Empty> 2001 2002 2003 2004
Actual 205 215 241 <Empty>
Forecast <Empty> <Empty> =261-241 <Empty>
Projected <Empty> <Empty> <Empty> 304

Now create a stacked bar chart on the data.