Thank you Andy, that worked, now I just have a formatting question - how can
I make the bars centered in between the tick marks for each month on the
graph?

"Andy Pope" wrote:

Hi,

You will find information on create that type of chart here,
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

tamir32880 wrote:
I need to make a graph that for each month, includes a solid bar (for
budgeted data) and a stacked bar (for 2 categories that make up actual data).
For the life of me I can't figure it out. Can anyone tell me if this is
possible, if so how to create it?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info