I'm using Office XP - Excel 2003.

I'm creating a bar chart by year. Each year has four separate values. The
values are LOI Received; LOI Invited; Proposals Received; Grants Awarded.

The LOI Invited value is a part of the total amount for LOI Received. For
example in 2004, we received 200 LOI's but we invited 150. I want my bar to
show the total of 200, but show the 150 carved out of the same bar that
indicates of the 200, we only invited 150. The same goes for Proposals
Received & Grants Awarded--of the total 265 proposals received, we awarded
215 from that total amount. Rather than having four separate bars per year,
I want only two bars--one for LOI information and one for Proposal/Grant
information.

I try using a stacked bar, but all four values become stacked on one bar.
How do I create a stacked bar, but select two value to stack in one and two
values to stack in the other, but still maintain all four values within the
same year. Your assistance is appreciated.