Assuming the title €œLOI€� is in cell B1 and €œPR & GA€� in cell C1, try setting
your data up like this:

LOI PR & GA
Invited 200 265
Received 150 215

Using the Chart Wizard, create a Clustered Column chart. Click once on the
second series of columns, right-click on your mouse - Selected Object -
Axis Tab - Plot series on secondary axis. Then go to the Options Tab and
increase the gap width for the second series. When complete, you should have
two sets of columns with the Received column appearing inside of the Invited
column.

----
Regards,
John Mansfield
http://www.pdbook.com


"B. Scace" wrote:

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.