I need to create a chart off of a spreadsheet with five variables I
have to show:
Room
Fiscal Year (2003, 2004, 2005, 2006)
Business Hour usage
After-Hours usage
Quantity (number of times the room was used that year)

Currently I have the data as Fiscal Year in rows by Business or After
Hours (FY03 Business Hours, FY03 After Hours, FY04 BH, FY04AH, etc.)
Rooms in columns, and Quantity as cell value.

What I want to do is create a stacked column chart that shows has Room
for the X-axis value, Quanity for the Y-axis, Fiscal Year on the Z-axis
(so it would be a 3-dimensional chart) and stack the Before and After
Hours values for each Room in each FY.

I can do a stacked value column chart, I can do a 3-D column chart, but
how do I combine them? I can't seem to find a way even in the Custom
Charts, even user-defined.

Is it that Excel can't create what I need? Or could it be that my data
is formatted incorrectly?

Hope someone can help, as the Boss wants this by lunchtime. He may have
to accept what can be done, rather than what he needs...